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…
DetailsContext 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…
DetailsVjeko, 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…
DetailsBecause 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…
DetailsIntroduction 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…
Details
