Allocate monthly amounts considering a Start and End Date – NAV Example

Let’s suppose that you have the following entries and what you need is an algorithm that will calculate the number of periods (months) between the End Date and Start Date and allocate the amounts equally for each period. Given: Result needed: How would you do this ? In this post I present 2 ideas about…

An attempt was made to change an old version of a record- NAV Error

I currently investigated the following NAV Error reported in a support incident: —————————— An attempt was made to change an old version of a Customer record. The record should first be reread from the database. This is a programming error. Identification fields and values: No.=’01121212′ —————————— This NAV error can appear on any record, I…

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…