RE: AP/AR aging report in base and foreign currencies
Hi, please suggest how to create AR/AP aging report with open balances in base and foreign currencies as of the report date. Amount in base currency shall reflect realized and realized gain/loss.
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