AP/AR aging report in base and foreign currencies
I see the issue here. A very common request, but unfortunately not possible. This is a known issue.
Aging reports are based upon the dates of the underlying transactions. That mains any unrealized gains/losses are displayed separately in the aging based upon the date those unrealized gains/losses were generated i.e. they are not tied to the specific invoice(s) they relate to nor included in the same aging bucket(s).
Please upvote and mark as best answer, so others can learn from this also. Thanks!
Hello, this is relatively straight forwards. Modify the AR/AP report and add a new column for the field labelled “Amount Due (Foreign Currency)”. I hope this helps! If so, please vote up and mark as the top answer, so others can learn from your question. Thanks!
Thanks for looking into this. We have problem with detailed aging report where invoice amount due in base currency includes original base value and realized exchange gain/loss. All unrealized gain/loss is shown as separate transactions for vendor/customer. We want to see amount due in base currency that includes both realized and unrealized exchange gain/loss . In other words if you multiple balance due in foreign currency by exchange rate on report date you should get amount in base currency