Hi All,
I have an issue where my Accounts Payable outstanding is different from the balance sheet
To explain the company is transacting on CAD and the payable account is at USD now I understand that the system books gl entries on two currency and that the exchange rate is used at the time of booking which can lead to the issue stated here How to maintain correct account balance in multiple currencies in case of foreign bank account?
I’ve done a exchange rate revaluation which have made the balance in CAD on the balance sheet closer to the Accounts Payable CAD value but it is still not the same. What I did notice is that there are invoices that has outstanding amount of 0.0001
Am i doing something wrong when doing the exchange rate revaluation? How can I make it so the Accounts Payable report matches the Balance sheet exactly?