01
About this report
For OneWorld accounts. Net sales by subsidiary and month over the last 24 months, where net sales are invoices and cash sales less credit memos, before tax. Each subsidiary's amounts are in its own base currency, named in the Currency column, so filter to one currency before adding subsidiaries together.
Group by Quarter or Year to compare subsidiaries over longer periods.
02
Sample preview
Fictional figures in the shape you will see. Yours come from your account.
| Month | Subsidiary | Currency | Transactions | Net sales |
|---|---|---|---|---|
| 2026-09 | Parent Co : US Operations | US Dollar | 48 | 262,400 |
| 2026-09 | Parent Co : Canada | Canadian Dollar | 17 | 88,150.50 |
| 2026-09 | Parent Co : UK | British Pound | 9 | 40,210 |
| 2026-08 | Parent Co : US Operations | US Dollar | 52 | 281,770 |
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(tl.subsidiary) AS subsidiary,
BUILTIN.DF(s.currency) AS currency,
COUNT(DISTINCT t.id) AS transactions,
SUM(-tl.foreignamount * t.exchangerate) AS sales
FROM transaction t
JOIN transactionline tl ON tl.transaction = t.id
JOIN subsidiary s ON s.id = tl.subsidiary
WHERE t.type IN ('CustInvc', 'CashSale', 'CustCred')
AND t.posting = 'T'
AND tl.mainline = 'F'
AND tl.taxline = 'F'
AND NVL(tl.iscogs, 'F') = 'F'
AND tl.itemtype NOT IN ('TaxGroup', 'TaxItem', 'Subtotal', 'Description', 'EndGroup')
AND t.trandate >= ADD_MONTHS(TRUNC(SYSDATE, 'MM'), -23)
GROUP BY TO_CHAR(t.trandate, 'YYYY-MM'), BUILTIN.DF(tl.subsidiary), BUILTIN.DF(s.currency)
ORDER BY period DESC, subsidiary