Today I want to present how to use Excel Buffer functionality in order to update/import data in NAV/D365 Business Central based on data from Excel files. Example of what we want to achieve To show the concept I made a very easy example, so let’s suppose we have the following customers with Location Codes: And…
I recently looked into a support incident where there were some problems when importing text data from an XML file into NAV. One of the problems was that in the xml file the string contained a lot of useless extra spaces. It looked somehow similar to this: So, in order to fix this, I created…
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…
If you want to ensure the security of your accounts, an option is to use randomly generated passwords for each account together with a password manager tool (for example I use lastpass). In this way you will need to remember only one password (for the password manager account) and you can use very strong random…
As you can only have a maximum length of 250 characters for a text field in NAV tables, it is often the need to store longer text related to a record. I also wrote about a workaround to something related to this, you can find the post here: Extended Comments in NAV Another possibility is…
In the Stock Exchange Bookkeeping App I wanted to be able to attach multiple files (ex: PDFs) to BVB Entries. The attachments are files received from the brokerage firm and they refer to a transaction. For example, if I buy 1 stock, I will have 3 BVB Entries with the same Transaction Number. If I…
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 this post I demonstrate two Simple Web Service examples of updating a NAV table from an external application using SOAP Web Services. We have table “Person Test” with “Person List” and “Person Card” pages and 3 fields which look like this: And we will create a C# Console Application in Visual Studio that will…
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…