AR Aging Summary in Foreign Currency Is it possible to create an AR Aging Summary report with amounts in TRANSACTION currency? I tried the Amount Due (Foreign Currency) field, but the custom report shows the amount due as of the date the report is run and not as of the date selected in the date filter at the bottom of the report.

I received this request from a client before, and it seems to me that it is not possible. We had to go through a saved search

But can you reflect the amount due and age AS OF ANY DATE SELECTED in a saved search? Basically a snapshot. As far as I know, saved search also shows the results as of the time you run it. Can't do snapshots for AR aging. I hope I am wrong though

That's interesting. I'm using a custom report with Amount Due (Foreign Currency) and the aging works as expected; account balances also reflect the balance as at the report date. Is it the total balance or the aging that's not working for you? If the latter, and excuse me if this is an obvious question, but are you updating the "age as of" date as well as the "date"?

@Angela it's the total balance. Are you able to share the Columns and Filters tabs of your report?

Mysterious! Attached is what I have. For further context, I've used this in 2 accounts, both reporting by date (not period) and we have multicurrency customers enabled. I can't think of any other preferences/settings which might be affecting this.