AP/AR aging report in base and foreign currencies

Answered

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.

Rookie Asked on August 5, 2021 in Reports.
Add Comment
3 Answer(s)
Best answer

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!

 

Beginner Answered on August 6, 2021.
Add Comment

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!

RE: AP/AR aging report in base and foreign currencies

Beginner Answered on August 5, 2021.
Add Comment

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.
  • This site made possible by our sponsors:   Tipalti   Celigo   Limebox   Become a Sponsor