When developing Extensions for NAV, using the Modern Development Environment in Visual Studio Code, you cannot use .Net Interoperability. See this link if you want to read more about this subject. So if you have NAV developments that use .Net and you want to move them into Extensions you will probably need to replace the…
Recently I got a requirement to increase the length of the comment field (for example in Customers, Vendors, Sales Documents, Contacts etc) as in standard NAV the comments limit is 80 characters per line. We could increase this limit, but the issue is that the maximum length of a text field accepted by NAV is…
Because I needed it recently for a unit test, today I will show you how you can validate an XML against a XSD schema in Nav. We have the following XSD schema: And we need to validate the below XML file against it: First, we need to convert ‘False’ into ‘false’ and ‘,’ from decimal…
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…
As you already might know, in the purchase/sales posting routines from NAV an additional temporary table Invoice Posting Buffer is used to group invoice lines by the fields specified in the Primary Key of Invoice Posting Buffer table (TAB 49) and then Post only 1 G/L Entry for each group of purchase/sales lines. In NAV…
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.
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…
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…
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…
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…