Aged Receivable and Payable Reports - Display Multicurrency Original Values
Reports - Display Multicurrency Original Values
Allow Reports to display the original values for a chosen currency.
Currently when running a Multicurrency report, the value shown is derived from the chosen Currency being exchanged from the BASE currency of the package. So if a ZAR base package has a €2000 Invoice in it, with a €2000 payment to a Euro account…. The profit and loss report, when run in Euros, will show that (today) as roughly €2037 after the back and forth conversions.
It would be very nice to have a reporting function that allowed the original values to be displayed, specially if they happen to be in the same currency as that chosen for the report and also regardless of the base currency.
Richard Muller
shared this idea
Appreciate wanting to be able to view the invoice original currency from the Aged reports.
Just for others coming across the idea here - The Payable and Receivable Invoice reports have column options to show original currency.
From the Aged reports you'll be able to click more to include 'Exchange rate note'. This will show an icon next to any lines that are foreign currency with a clickable note that depicts the detail of the exchange rate for that invoice.
This isn't something we have any plans of adding to the Aged reports at present but we'll continue to track the interest and update you if there are any changes planned.
-
Sam Haworth
commented
Aged Receivables / Payables Detail Report - once exported to Excel, can the FX columns just come out at the start of the columns before <1 month or have one currency column to note which currency the invoice is?
-
Kerry Bridle
commented
would it be possible to have Aged Receivables Summary/Detail in Currency and Base like the picture attached
