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…