Forum Discussion

McCarthy1's avatar
McCarthy1
Experienced User
6 years ago

Foreign currency

Hi 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...
  • Mike_James's avatar
    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.
McCarthy1's avatar
McCarthy1
Experienced User

Thanks for that Mike.

I have tried and can't find a filter in the Summary Report to filter by currency

Mike_James's avatar
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's avatar
    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?

     

    • Steven_M's avatar
      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's avatar
        McCarthy1
        Experienced User
        6 years ago

        Thanks for that, great help

Looking for something else?

Search the Community Forum for answers or find your topic and get the conversation started!

Community home

Dig into MYOB Academy for free courses, learning paths and live events to help build your business with MYOB.