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.

Sukhanovska Rookie Asked on August 5, 2021 in Reports.
Add Comment
3 Answers

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

Rookie Answered on August 6, 2021.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.