Business Central Execute Queries from Pages

With the QueryCategory property we can execute a query object from a page (also available in Smartlists) by defining a query in AL; it is possible to declare with a comma separated list where the object can be used, in practice it is added to the list of objects published in the SmartList.

Source : Roberto Stefanetti Blog – Microsoft Dynamics 365 Business Central
Read more…

The Rules Pattern in Business Central – AL Language

The Rules Pattern is a Design Pattern to simplify the complex business logic which is based on multiple if-else statements. Using this Design Pattern each if-else branch in the business logic is segregated into a separate rules and also the processing logic is separated from the rules.

Source : msnJournals
Read more…

Monitoring changes in Dynamics 365 Business Central 2020 release wave 2 (Change Logs, Field Monitoring and Data audit system fields)

A common challenge in many business management applications is avoiding unwanted changes in data. It could be anything from an incorrect customer name to an incorrect posting to the general ledger. In this blog we will summarize how to Monitor Changes in Dynamics 365 Business Central 2020 release wave 2. There are currently three ways.

Source : Dynamics 365 Lab
Read more…

Tic-Tac-Toe in 98% pure AL

In my last video, I asked if viewers wanted to see me create a Tic-Tac-Toe game in Microsoft Dynamics 365 Business Central. Lots of viewers wanted that.

Tic-Tac-Toe in AL is nothing new, Vjeko did it back in 2017 as a demo of the Javascript control addin, so for this to be a challenge, it should be done in pure AL without using Javascript for UI.

Source : Hougaard.com
Read more…

Dynamics 365 Business Central: new features for performant code

In the training I’ve done to some partners last week, when talking about performances I shared an example of an extension with 3 features that I think are not so well known but that have a significant impact on how your code performs, expecially on a SaaS environment. That extension used the following features:

-Partial record loading
-Temporary Tables
-QueryCategory

Source : Stefano Demiliani
Read more…