Introduction I did not write on the blog for a long time because I was too busy working on projects and was not in the mood for blogging. But today I want to write about the new concept of abstraction introduced in AL in 2020: D365 Business Central interfaces. So, first what are interfaces and…
Introduction Recently I worked on something very interesting related to a integration between MS Dynamics Nav and an external payment service provider. I had to use custom Cross Session Events to solve a problem which I think it’s worth sharing. So this why this post. Basically, it is about doing some action in a NAV…
Introduction Recently I encountered the following situation in Business Central with Web Service that uses Pagination with Continuation Tokens: –> When you get data from Web Service and it returns a lot of results, the data is paginated. –> One method to handle pagination is using Continuation Tokens. –> For example, look at the below…
Introduction In this post I presented a very simple way to import data from Web Service Response into Business Central Wave 2. However, that approach is not a generic one. Let’s now create a Distance Calculator for Business Central that can be used in real life. The current post presents a better way to Import…
Vjeko, wrote some very good posts about the bad performance of COUNT function used in Microsoft Dynamics NAV. You can check them out at the end of this post. COUNT function can be used in NAV to find out how many records with certain filters you have in the database. Let’s take a simple example…
Because I didn’t write on the blog since a long time, today I will demonstrate how you can use the AL language in Microsoft Business Central to import data exposed by a REST Web Service in JSon format. As usual, I created a practical example to demonstrate better the concepts. What REST Web Service we…
In this post I described a way to deal with Extension Files Info in NAV AL (Business Central). Now I decided to create a small module that will help you manage the Extensions and Ids. Besides what I showed in the first post, I added to the module an extra feature: now you have the…
Because I needed it today for simulating a response of a web service in a unit test and couldn’t find a suitable example over the internet, let’s see how we can create a Simple Json file in NAV C/AL. Sample test codeunit: Variables function Create SimpleJsonFile: Var Name DataType Subtype Length Yes JSonResponse DotNet Newtonsoft.Json.Linq.JObject.’Newtonsoft.Json,…
In order to exercise in the new NAV Modern Development Environment I thought to implement a comparison of two sorting algorithms directly in Visual Studio Code AL Language: Insertion Sort and Merge Sort. Most of the sorting examples over the internet are using arrays, but the issue with arrays is they have fixed length that…
It might seem boring to discuss about this, but passing variables By Value vs By Reference in NAV AL (as in other languages) does not always behave the same (depending on the type of variable). In this post I will explain the differences as this is an important thing to understand. Let’s compare passing a…