I have a user of Navision 4.0 who is trying to run Navision report 120 “Aged Accounts Receivable” as at 31/03/06 and printing amounts in LCY. The overall total of the report does not tie in with the relevent G/L account filtered balance for the same date range.
The “Direct Posting” option is unticked on the G/L account and I am happy that all entries have come directly from customer transactions or from Currency exchange variations.
I have identified the customer accounts with discrepencies but there are hundreds of transactions to trawl through to try and pinpoint specific problem transactions.
Has anybody encountered this problem before and know of any quick fixs or do I have to go through all the customer ledger entries to compare the LCY amount to the equivelent entry on the G/L entry Table. (I have a sneaking suspicion that it may be where “Reverse Transaction” or “Unapply Entries” have been used)