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…
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…
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…
Many times when creating processing reports in Microsoft Dynamics NAV, after the report processes all desired data, you might want to display for the user a log with what happened or with the errors that occurred. You can use for example IF Not ExampleCodeunit.Run THEN store the errors (with the help of function GETLASTERRORTEXT) in a DotNet list, process…
In this post I will present some important information about the Microsoft Dynamics NAV Document Pattern. A document in NAV contains a Header with common data and one or more Lines. Each line is linked to the header. Let’s have a look for example at a Purchase Order. As you can see in the bellow image, a…
There might be situations when you would like to set a trial period for your Excel applications: maybe you want to prevent employees take the applications and use them forever in other places after they leave your company or you simply need to provide to a client a trial that can be tested only a limited…