01
About this report
For accounts that bill in several currencies. The report gives the invoice count and total, tax included, per currency and month over the last 24 months. Totals are shown in the invoice currency and in base currency at each invoice's exchange rate. Average rate is the base total divided by the currency total.
Use it to size currency exposure or to check that exchange rates look right. Filter on Currency to follow one currency.
02
Sample preview
Fictional figures in the shape you will see. Yours come from your account.
| Month | Currency | Invoices | Total (invoice currency) | Total (base currency) | Average rate |
|---|---|---|---|---|---|
| 2026-09 | US Dollar | 22 | 186,400 | 186,400 | 1 |
| 2026-09 | Canadian Dollar | 9 | 64,200 | 46,866 | 0.73 |
| 2026-09 | Euro | 3 | 18,900 | 20,601 | 1.09 |
| 2026-08 | US Dollar | 25 | 201,150 | 201,150 | 1 |
03
The SuiteQL
This is the query each report runs. Read it, copy it, or change it after import.
SELECT TO_CHAR(t.trandate, 'YYYY-MM') AS period,
BUILTIN.DF(t.currency) AS currency,
COUNT(*) AS invoices,
SUM(t.foreigntotal) AS total_fx,
SUM(t.foreigntotal * t.exchangerate) AS total_base,
SUM(t.foreigntotal * t.exchangerate) / NULLIF(SUM(t.foreigntotal), 0) AS avg_rate
FROM transaction t
WHERE t.type = 'CustInvc'
AND t.posting = 'T'
AND t.trandate >= ADD_MONTHS(TRUNC(SYSDATE, 'MM'), -23)
GROUP BY TO_CHAR(t.trandate, 'YYYY-MM'), BUILTIN.DF(t.currency)
ORDER BY period DESC, total_base DESC