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…
So, you need to retrieve from the database all customers with the Name = ‘John’ OR the Email = ‘[email protected]’ in order to make something with each record from the resulting dataset. In other words you need to use a Multicolumn OR filter. What is the best way to do this in NAV? Please do…
Context Few days ago I created a NAV Report that did some checks and processing. After this, it uses a Temporary Data Item to print values in the layout for the user to see what records are updated or have issues. Because of the complexity of the checks and processing I had to use a…
Context of the issue I recently needed to add a very long text (about half of page with Terms and Conditions of Sale) only on the last page of a RDLC Invoice Document (using Visual Studio Report Designer to create report documents for NAV). The last page had to contain only this text and not…
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…
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…
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…
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…