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 It might be useful to calculate distance between locations of stores in NAV. This can help for example in order to let customer know which is the nearest location in which a product is in stock. In case product is not in stock in the location where the customer is, for example. One method…
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 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…
Let’s suppose that you have the following entries and what you need is an algorithm that will calculate the number of periods (months) between the End Date and Start Date and allocate the amounts equally for each period. Given: Result needed: How would you do this ? In this post I present 2 ideas about…
In November I attended NAV TechDays 2016 in Antwerp and one of my favorite sessions was the one held by Gunnar Gestsson about migrating to events. You can see and download the recording following this link from his blog. I liked a lot the efficiency test on 4 grouping methods that he made in the last…
Many times when creating processing reports in Microsoft Dynamics NAV, after the report processes all desired data, you might want to display for the user a log with what happened or with the errors that occurred. You can use for example IF Not ExampleCodeunit.Run THEN store the errors (with the help of function GETLASTERRORTEXT) in a DotNet list, process…
There might be situations when you would like to set a trial period for your Excel applications: maybe you want to prevent employees take the applications and use them forever in other places after they leave your company or you simply need to provide to a client a trial that can be tested only a limited…
In this post I will demonstrate how to use Dictionaries in Excel VBA in order to calculate, store and use data summarized on different criteria. In the real life I used the algorithm from this post to automate the issue of inter-company invoices. This automation saved dozens of hours considering that before they had it, users where issuing…