All Around Microsoft Dynamics NAV

Allgemein

Business Central 140 has two ways to work with symbols. Way 1 – The default way Business Central used the symbols containing in the extension Application of the database. This is the best way if the target database has no C/AL changes. If you are updating the database to a newer CU release you need […]

Weiterlesen

Running a nav container on azure is really simple. First we need to open an azure Cloud Shell (I prefered PowerShell). Now we create a resource group for our containers (Name navgroup, location westeurope). PS Azure:\> az group create -g navcontainer –location westeurope And now we can create easily a NAV2018 container (in this sample […]

Weiterlesen

I created a simple Dockerfile and a Powershell script to create an custom docker image based on an offical Microsoft image. Based on an custom image you can create multiple Test and/or Development Environments with an minimum storage footprint.   Only five steps are needed to create an custom image. Make a backup of the database […]

Weiterlesen

The Problem Currently it is not possible in NAV to detect the ouputtype of an Report in NAV (Print, PDF, HTML, EXCEL). A Possible solution In older NAV version I created a SetPdfPrint and IsOdfPrint method in an „Single Instance“ codeunit and before the REPORT.SAVEASPDF(…) method is called I call the SetPdfPrint(TRUE) method and after the […]

Weiterlesen

In previous versions of Microsoft Dynamics NAV, the filter length is limited to 1024 characters. With Microsft Dynamics NAV 2017 the filter length is „unlimited“. But you have to be carefull. The Microsoft SQL Server allows per default only 2100 parameters in a SQL statement. The following Standard NAV code will throw the exception „Too many parameters […]

Weiterlesen

I work at a Microsoft Dynamics NAV Partner and we use Dynamics NAV also as a ticket system and a planning tool for our tasks. Often, I get E-Mails like: ”Hey Thomas, can you check T00010 for me?“ or „Can you check Task 000015A“.So, it would be quite nice to see the Dynamics NAV content […]

Weiterlesen