Dynamics NAV/BC – Events Stack Logging

This post shows you how I created a logging system to know when, from where and by whom an event was called. The following solution can be used in Dynamics NAV 2017 or later because it uses TryFunctions and the GETLASTERRORCALLSTACK command. (In Dynamics NAV 2016 TryFunction is available but I’m not sure if GETLASTERRORCALLSTACK […]

Printing on roll paper in Dynamics NAV

I want to show you how I was able to print invoices and credit memos (or other reports) on a roll paper printer from Dynamics NAV. I was using Dynamics NAV Universal App in a tablet with Android and I wanted to print to a printer connected via Bluetooth. If you tried it, you’ve already found […]

Dynamics NAV Server hack by examples

If you want to handle different Dynamics NAV Server versions, ServiceTierAdministration is the way. No doubt about it. You may download it from Mibuso: https://mibuso.com/downloads/service-tier-administration-tool But you can do it using Windows sc command and/or hacking the Windows registry. So let’s learn how to do it by examples: 1. How to create a new service instance named […]

Excel Buffer – Detect Excel’s Language

Dynamics NAV allows you to “easily” export information to an Excel file, via code, using the Excel Buffer table. To export a cell value as a formula, you may add and use the following function to your object: LOCAL EnterFormula(RowNo : Integer;ColumnNo : Integer;CellValue : Text[250];Bold : Boolean;UnderLine : Boolean;NumberFormat : Text[30]) ExcelBuf.INIT; ExcelBuf.VALIDATE(“Row No.”,RowNo); […]

Error importing NAV License in AzureSQL Database

When opening a database installed in AzureSQL, you may get this error: The database on the server requires a Per Database license to be opened on SQL Azure You must use Powershell to import the Dynamics NAV license. To import a license file to a AzureSQL database I used the following command: Import-NAVServerLicense DynamicsNAV100 -LicenseData ([Byte[]]$(Get-Content -Path […]

NAV 2015 Webservices (simple) connection problem

I was preparing a training session about Dynamics NAV 2015 and I was using a Cronus database that was already installed in my computer. I’ve added the Customer Card to Web Services and published it, just to test it. When I was going to connect to the webservice using .NET WS Studio, I got the […]

Running an object opens a new session

I was using Dynamics NAV 2013 R2 stock version and i’ve installed the cumulative update 6 for Dynamics NAV 2013 R2. After that, when I try to run an object in the Development Environment, a new Dynamics NAV session is opened instead of running the object in the currently opened session. This happens because in […]

Code Genius 7.0 with NAV 2013 R2 error

Hi, I was trying to use Code Genius Studio (7.0.2.3018) with Dynamics NAV 2013 R2 Build 36366 (Cumulative Update 6) and I got this error when opening the Classic SQL client. Microsoft Dynamics NAV ——— The program property ‘company’ is unknown. The manual Installation and System Management contains a list of the correct program properties. […]