Foreign currency

I have 2 currencies and would like to be able to view my Accounts Receivable Report in their correct currency. At the moment they are all showing in the main currency although I have created them in their own currency

Mike_James
6 years ago
Hi  , in 2019.2 you can run the Receivables & Payables Reconciliation Summary reports, and filter those two by currency, and tick the option to display ageing in originating currency. At the moment the detailed versions of those two reports do not have these options. I'm hoping to see them in the next release, but that won't be until August. A statement in foreign currency can't be produced either. 
 
The API endpoint for item and service invoices includes "BalanceDueAmountForeign". For a file in a local library, there are ways to extract this data using Excel, and it could then be grouped by month and summarised in a pivot table.
 
Note that there is no foreign currency receivable account in the GL, as there used to be, so the f/c receivables reports can only be reconciled in your home currency.

6 Replies

Replies have been turned off for this discussion

Mike_James
Ultimate Cover User
6 years ago
Hi  , in 2019.2 you can run the Receivables & Payables Reconciliation Summary reports, and filter those two by currency, and tick the option to display ageing in originating currency. At the moment the detailed versions of those two reports do not have these options. I'm hoping to see them in the next release, but that won't be until August. A statement in foreign currency can't be produced either. 
 
The API endpoint for item and service invoices includes "BalanceDueAmountForeign". For a file in a local library, there are ways to extract this data using Excel, and it could then be grouped by month and summarised in a pivot table.
 
Note that there is no foreign currency receivable account in the GL, as there used to be, so the f/c receivables reports can only be reconciled in your home currency.
Steven_M
Former Staff
6 years ago
Hi McCarthy1

In the screenshot you have provided, I can see that you are running the Aged Receivables Summary report. Currently, the originating currency is available on the Receivable (or Payable) Reconciliation Summary report, 2 down in the Index to Reports>>Sales tab.

Other reports in AccountRight 20xx range may receive the option to display in the originating currency with future updates but this has not been included in the AccountRight 2019.2 version.
McCarthy1
Experienced User
6 years ago
Thanks for that Mike.
I have tried and can't find a filter in the Summary Report to filter by currency
Mike_James
Ultimate Cover User
6 years ago
Hi McCarthy1 , the currency filter should be visible on the toolbar if the Filter tab is selected. (The Ageing option is to the right on the same toolbar). This applies to the AR and AP Reconciliation summary reports only.
McCarthy1
Experienced User
6 years ago
Hi Mike
Sorry to be a pain. I open Reports, select Ages Receivables (Summary).
I've attached 2 screen shots of what I get.
I select Display Report or Advanced Filters and get the same screen but can't see anywhere to select currencies?

Am I missing something or in the wrong place?

MYOB Debtors.docx123 KB
McCarthy1
Experienced User
6 years ago
Thanks for that, great help