msnJournals

Webhooks is a great feature introduced in Business Central to notify other applications about data changes occurring in entities. Webhooks are a way for applications to communicate between them automatically. When a record is created / updated / deleted in Business Central, a notification is sent to the subscriber automatically. Comparison between Publisher-Subscriber Events and Webhooks Webhooks' design pattern is very similar to Publisher-Subscriber events in AL, but it is

Anomaly Detector is an Azure Cognitive Service that detects anomalies in time-series data. It consists of simple REST APIs that can be consumed by any application. This post explains how to setup Azure Anomaly Detector Service, and how to consume Anomaly Detector REST APIs in Business Central using AL Http datatypes. Why and Where to find Anomalies Purpose of Anomaly Detector is to identify unknown threats in time-series data. Anomalies can be detected in any time-series data

Inline Query Analyzer is a tool to analyze data in Business Central. This is an open source project intended to help developers for quick retrieval of data for analysis purposes. You can write SQL like queries to retrieve data. Users can view the query results in Grid and JSON views. How to install? This is an open source AL Project, source code can be downloaded from https://github.com/msnraju/inline-query. This tool is using Object IDs from 50100 to 50149, you may need to r

Inline Query is a library that can execute SQL like Queries in Business Central AL Language. This is a small compiler in AL that compiles and executes SQL like queries in text constants or text variables. Query Object vs Inline Query Inline Query is not a replacement for Query Objects. At present, Inline Query can only support retrieval of a single column from a single table (joins are not supported). Whereas Query Object supports multiple tables and multiple columns. Why Inl

Facade Pattern is a Design Pattern to hide complexity of the multiple sub systems by providing a simple interface to the client. This pattern involves a single codeunit which provides simple methods required by the client and delegates call to methods of existing internal codeunits. Class Diagram Facade pattern class diagram: Subsystem: Each class / codeunit in Subsystems has some functionality that will be accessed by client using Facade. Facade: This will be the interface f

Understand the basics of JSON data types and how to handle JSON data in Business Central AL Language using JSON data types.

The Rules Pattern is a Design Pattern to simplify the complex business logic which is based on multiple if-else statements.

Generic Validator Method Pattern is a design pattern which is an extension of Generic Method Pattern. Purpose of this design pattern is to validate one or more entities in a specific context. This is a very commonly used pattern in other languages, just that it is adjusted to Generic Method Pattern. Generic Method Pattern It has a public method and two business events which can be subscribed to change or extend the behaviour of the method. Public Method may contain the follow

Control Add-in is an Object type in Business Central to develop User Controls using JavaScript, and CSS. Though it is a very good option to enhance UI / UX in Business Central, we often have to struggle to build HTML markup in JavaScript, because we have to use string concatenate functions, or complex DOM methods build HTML elements. ReactJS library can give us the flexibility to write HTML markup inside JavaScript. About ReactJS ReactJS is a JavaScript library developed by t

Learn how to read, upload, download, and delete files from SharePoint Document Library using AL Code in Microsoft D365 Business Central.

How to get OAuth Access Token from Azure AD, Google, Facebook etc in Business Central. Download source code from GitHub.

In AL there is a codeunit called Cryptography Management (Codeunit 1266) which provides helper functions for encryption and hashing. Cryptography is used to keep the data safe by encrypting and depcrypting the data so that others canot misuse the data. This post covers only basic usege of Cryptography Management codeunit. The following are the topics convered in this post. Encryption Key Importing / Exporting Encryption Key Encrypt / Decrypt data Encryption Key Encryption Ke

Learn how to solve Table Locking issues in Microsoft Dynamics 365 Business Central / NAV with code examples.

Learn How to add Custom Filter Tokens Functionality in Business Central. You use Custom Filter Tokens in page advanced filters to apply filt

Assisted Setup is a wizard page to help Business Central User setting up a module. When you are creating an extension for Business Central, you must consider creating one or more Assisted Setups for your extension. Wizard Page: Assisted Setup is nothing but a wizard page (guided page) containing one or more steps to help Business Central User to configure setups. Page layout: Page contains at least two steps, start and finish (welcome and thanks) steps. Each step is a field g

Createing Controls Add-in is not that difficult. Just read this post you will understand how easy it is.