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…
DetailsBecause 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…
DetailsLet’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…
DetailsAs 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…
DetailsFind 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
