Introduction Because this post https://andreilungu.com/read-write-text-from-to-blob-field-nav/ is one of the most read posts from my blog, I decided to write about how to read/write data from/to multiple blob fields in a generic way (without duplicating code). Functional description For example, I used this when I had 2 BLOB fields in a setup table where I needed…
Today I want to discuss about how to populate a sub page with SourceTableTemporary in a Wizard. In the following example I am using the NAV mobile web client. In addition, I blurred real app data because in real life I used this for other specific things. 1) First, let’s see an example of what…
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…
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…