Read/Write Text Data From/To BLOB Fields in a Generic Way- Nav

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…

Distance Calculator for Business Central – Another way to Import Response from Web Service into Business Central Wave 2

Introduction In this post I presented a very simple way to import data from Web Service Response into Business Central Wave 2. However, that approach is not a generic one. Let’s now create a Distance Calculator for Business Central that can be used in real life. The current post presents a better way to Import…

How to use a sub page with SourceTableTemporary in a Wizard – NAV/Business Central

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…

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…

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…