How do a get a report that gives me sales and debtors in foreign currency? If I'm chasing a customer who I have billed in USD I don't call them and ask to pay me the AUD amount based on the prevailing exchange rate. It looks like it should be possible because if I produce a statement for a customer it shows in original currency but there don't seem to be any reports that allow to do this for all customers at once rather than individual statements for each customer.
Hi MickyH75 - if you choose the Receivables or Payables Reconciliation Reports there is an option to choose the currency, but i have never been able to generate a statement in foreign currency
Hi MickyH75,
You’re right to question it. In AccountRight Premier, multi-currency can track customer and supplier transactions in their original currency, but not every report will show those values in the originating currency. At the moment, there isn’t a single built-in report that will show all sales and debtors for all customers in their foreign currencies in one view.
For outstanding debtor balances, the best built-in option is the Receivables Reconciliation [Summary] report. You can run that report, choose the foreign currency, and tick Display Ageing in Originating Currency to see balances in that transaction currency. More information on this help article: Working with multiple currencies
Regards,
Earl
