How to generate a supplier Fast Report in another currency?

MM_7769277
MM_7769277 Member Posts: 115 ✭
edited February 2017 in Accounts Hosted
I have a supplier in my AP ledger who invoices in USD so I have them set up with USD as their currency. All invoices are inputted in USD.

We have had a minor dispute over the statement and I want to produce a Fast Report to show all the invoices and bill payments over the last 12 months.

Is there any way I can get it to display USD and not AUD??


Comments

  • gazza73
    gazza73 Accredited Partner Posts: 803 Accredited Partner Accredited Partner
    edited February 2017
    MM

    refer to the SUPPLIER CENTRE to locate the name of the supplier in question.  That supplier will have its native currency as say:  USD.

    Right-click on the name and choose FAST REPORT to see all the transactions.

    THEN whilst viewing the report on your screen, go to MODIFY menu and select these three additional COLUMNS (fields) to see on your report:  (about midway down the long list)
    -  Actual Rate
    -  Foreign Amount
    - Currency

    Also:  modify the HEADER/FOOTER  and change the REPORT TITLE to something useful like "Supplier Analysis in Multiple Currencies",    say OK to all that and finally MEMORISE that as a useful future report.

    Here's the result 

    image

    Gary Pope
    m: 0408994799
    e:  gaz@alchester.com.au 
    An Accredited Partner- Consultant (VIC. Aust)
    http://www.alchester.com.au/reckon-ac...
    "Working with Accountants/Bookkeepers PPs/APs, as an
         independent IT Professional and retired FCPA Accountant"

  • MM_7769277
    MM_7769277 Member Posts: 115 ✭
    edited February 2017
    Brilliant!!!
  • gazza73
    gazza73 Accredited Partner Posts: 803 Accredited Partner Accredited Partner
    edited December 2016
    MM - terrific, glad you're sorted again.  I notice we've helped you with a number of different matters lately.  I'd appreciate a call.   Gary

Categories