I am using NAV 2009 R2 with multi currencies. For our November month end we decided to change how the f/x was being recorded and used the monthly average in the Relational Adjmt Exch Rate Amt column. Now when I run my November Aged A/P report it no longer balances to the G/L. It looks like the G/L and subledger are each using a different f/x amount. How does one go about fixing this so they balance once again?
Aged creditor report runs from vendor ledger entry table but the revaluation batch job records changes re exchange rates at detailed vendor ledger. So may appear to be out of balance but detailed vendor ledger table accurately reflects GL.
Solution is to create new aged creditor report off detailed vendor ledger entry! We have developed these for quite a few clients.
Hope this helps!
Is this report something we would require a programmer to do? Or is this a report we could create ourselves.