Recently I had the need to use a Secondary Key to sort a RecordRef. As I could not find another clear example, I decided to share my solution here. Introduction To make it easier to understand, let’s assume we have this Test table with only 2 fields, both Integers just to simply the example: The…
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 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…
What is a Unix Time Stamp? As per Wikipedia, a Unix Time Stamp is a BigInteger value that represents the number of seconds that elapsed since the time 00:00:00 UTC on 1 January 1970. For example using this converter you can see that the Unix Time Stamp ‘1588400673’ represents date time ’05/02/2020 @ 6:24am (UTC)’.…
Recently I investigated an issue in D365 Business Central version 14.0.29530 with Message function not working in a processing Report. When debugging the code, the Message function is executed in the report code, but in the Business Central Web Client interface the message is not displayed. This looks like a very strange issue. You can…
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…
Introduction In this post I demonstrate how you can get XML data from a Web Service and then process the XML in NAV in order insert the needed values into a table. I made the example using a service provided by the National Bank of Romania. This Web Service, gives Exchange Rates in XML format…
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…
In AL VS Code Extensions V2, if you try to create an extension and the ID or Name are already used, you get this error: Because we don’t have the extension id in the name of the file (I assume you don’t have it either), you can use the following Powershell script to check what…