All Around Microsoft Dynamics NAV

TWI

Beliebt

Print Logo on Reports only if sending via E-Mail (NAV2016 and higher)

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 […]

Extending the new Office Add-Ins of Microsoft Dynamics NAV 2017

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 […]

Filter length for SETFILTER in Microsoft Dynamics NAV 2017 and the 2100 parameters issue

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 […]

Letzte Beiträge

Business Central 140 Symbols

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 […]

Run nav-docker on Azure

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 […]

Create Dynamics NAV Docker images with a custom SQL database

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 […]

Print Logo on Reports only if sending via E-Mail (NAV2016 and higher)

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 […]

Filter length for SETFILTER in Microsoft Dynamics NAV 2017 and the 2100 parameters issue

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 […]

Extending the new Office Add-Ins of Microsoft Dynamics NAV 2017

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 […]