How to Add Long Text on Last Page of RDLC Invoice Document in NAV / Business Central

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…

Using REST Web Service to Import Json Data in Business Central

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…

Excel Buffer Patterns for Import or Update NAV Data from Excel Files

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…

How to Create a Simple Json File in NAV C/AL and AL

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,…