How to use Powershell to automate some basic NAV tasks

In this post I want to present some sample Powershell scripts that I created to automate a couple of basic tasks related to Microsoft Dynamics NAV. Please change the parameters before you use them. Create new NAV 2016 Environment: restores specified database backup, creates NAV Server Instance, starts NAV server Instance Drop the specified database…

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…

The Document Pattern and the link between Header and Lines in Microsoft Dynamics NAV

In this post I will present some important information about the Microsoft Dynamics NAV Document Pattern. A document in NAV contains a Header with common data and one or more Lines. Each line is linked to the header. Let’s have a look for example at a Purchase Order. As you can see in the bellow image, a…

Microsoft Dynamics NAV Dimensions – Overview

When I first started to work with MS Dynamics NAV, I needed to understand some of the most important concepts related to Dimensions: what’s the difference between global dimensions, shortcut dimensions, default dimensions, what are default dimensions priorities, what are dimension set entries etc ? I couldn’t find an article on the internet that demonstrates all these concepts starting with…

Excel Hire Test version1

As you might noticed, Excel is one of my passions, so I always thought about creating an Excel Hire test that would test the knowledge of candidates about the most important Excel concepts. So here it is 🙂 What covers this test ? Lookup Functions: vlookup, index and match Basic Reference Function: offset Basic Date…

How to implement trial period or protection for your Excel Add-ins or workbooks using Excel VBA

There might be situations when you would like to set a trial period for your Excel applications: maybe you want to prevent employees take the applications and use them forever in other places after they leave your company or you simply need to provide to a client a trial that can be tested only a limited…

An example of how to use Excel VBA Dictionary of arrays data structure

In this post I will demonstrate how to use Dictionaries in Excel VBA in order to calculate, store and use data summarized on different criteria. In the real life I used the algorithm from this post to automate the issue of inter-company invoices. This automation saved dozens of hours considering that before they had it, users where issuing…