Using NAV SumIndexFields in the Stock Exchange Bookeeping App
Find out how NAV SumIndexFields Technology works. I used it in my Stock Exchange Bookkeeping Application in order to calculate fast the Average Buy Price.
Details
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…
Details
NAV Dimension Set ID not in line with Global Dimensions 1 and 2 (how to fix)
As a result of some bad development you might find yourself in the situation to have G/L Entries with a Dimension Set ID that does not contain or contains incorrect Global Dimensions 1 and 2. If you are new to Dimensions I recommend to first read my Dimensions Overview post. I had this situation and besides…
Details
Ways of Grouping Data in Dynamics NAV C/AL from NAV TechDays 2016
In November I attended NAV TechDays 2016 in Antwerp and one of my favorite sessions was the one held by Gunnar Gestsson about migrating to events. You can see and download the recording following this link from his blog. I liked a lot the efficiency test on 4 grouping methods that he made in the last…
Details
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…
Details