AP Open Account Balances in foreign/transaction currency
Hello,
We need to reconcile the AP open account balances on foreign / transaction currency. The AP Trial Balance (APTB) and Open Account Balances report do show a currency, but that is our functional currency (the XML shows that this is the Ledger Currency Code).
How can we create an Open Balances list per Ledger Account, per Supplier on a given date (the aging report is "as of now" and does not help with the reconciliation)? Any suggestion is welcome!
Thank you, Danny