I’ve just shared a few cheat sheets that I’ve created, with Docker, Business Central, Powershell and NAVContainerHelper commands and a few more useful things. I’ll keep adding more things over time. You can find the link below as well as in the navigation bar. Hope you find it useful.
#dynamicsnav #businesscentral #msdyn365bc #designpatterns In Dynamics NAV/BC development we often see a method with a lot of parameters. Take as an example the method FormatAddr in codeunit Format Address. procedure FormatAddr(var AddrArray: array[8] of Text[100]; Name: Text[100]; Name2: Text[100]; Contact: Text[100]; Addr: Text[100]; Addr2: Text[50]; City: Text[50]; PostCode: Code[20]; County: Text[50]; CountryCode: Code[10]) If we […]
Eric Walters (Waldo) shared a great tool developed “on top of” the existing Microsoft.Dynamics.Nav.Model.Tools.dll, which is a library that serves the PowerShell Merge-CmdLets provided by Microsoft, that allow us to do a bunch of analysis on top of NAV/BC objects (man, you rock!). More info here: https://www.waldo.be/2019/02/15/c-al-source-code-analysis-with-powershell/ And here: https://github.com/waldo1001/Waldo.Model.Tools I have created a script […]
BINDSUBSCRIPTION is a function in Dynamics NAV and Business Central that is not very well know (yet) but it is very handy on several situations. If you’re already embracing the beautiful (and challenging) world of events then you’ll surely use the BINDSUBSCRIPTION function. In this article I will present you with 3 usage examples. None […]
In my previous article Dynamics NAV Server hack by examples I’ve enumerated some tips on how to create and maintain NAV servers in a very hacky way. In this article I want to show you how to use Powershell modules with the same NAV/BC version but different cumulative updates on the same machine. Please note […]
In the last weeks I’ve read a few posts about C/SIDE to AL Data Migration and as far as I understand people are struggling to have data migrated from C /SIDE to AL tables. Data upgrade codeunits to the rescue. They exist in C/AL and exists in AL as well so you should use and […]
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 […]
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 […]
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 […]
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); […]