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…
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.
DetailsI 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…
DetailsAs 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
