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

Allocate monthly amounts considering a Start and End Date – NAV Example

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…