In the Stock Exchange Bookkeeping App I wanted to be able to attach multiple files (ex: PDFs) to BVB Entries. The attachments are files received from the brokerage firm and they refer to a transaction. For example, if I buy 1 stock, I will have 3 BVB Entries with the same Transaction Number. If I…
Because I needed it today for simulating a response of a web service in a unit test and couldn’t find a suitable example over the internet, let’s see how we can create a Simple Json file in NAV C/AL. Sample test codeunit: Variables function Create SimpleJsonFile: Var Name DataType Subtype Length Yes JSonResponse DotNet Newtonsoft.Json.Linq.JObject.’Newtonsoft.Json,…
In this post I demonstrate two Simple Web Service examples of updating a NAV table from an external application using SOAP Web Services. We have table “Person Test” with “Person List” and “Person Card” pages and 3 fields which look like this: And we will create a C# Console Application in Visual Studio that will…
It might seem boring to discuss about this, but passing variables By Value vs By Reference in NAV AL (as in other languages) does not always behave the same (depending on the type of variable). In this post I will explain the differences as this is an important thing to understand. Let’s compare passing a…
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.