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…

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…

DotNet List in NAV 2016

How to use a DotNet List to display a multi-column Report in Microsoft Dynamics NAV 2016

Many times when creating processing reports in Microsoft Dynamics NAV, after the report processes all desired data, you might want to display for the user a log with what happened or with the errors that occurred. You can use for example IF Not ExampleCodeunit.Run THEN store the errors (with the help of function GETLASTERRORTEXT) in a DotNet list, process…

How to implement trial period or protection for your Excel Add-ins or workbooks using Excel VBA

There might be situations when you would like to set a trial period for your Excel applications: maybe you want to prevent employees take the applications and use them forever in other places after they leave your company or you simply need to provide to a client a trial that can be tested only a limited…