01
About this report
One row per expense or item line of a posted vendor bill or vendor credit in the last 24 months, before tax, in base currency, with credits negative. Each row gives the month, date, vendor, type, document, account, item, memo and amount.
Opened from Vendor spend by month, it arrives filtered to one vendor and month. On its own, filter by Account to see what a cost is made of.
02
Sample preview
Fictional figures in the shape you will see. Yours come from your account.
| Month | Date | Vendor | Type | Document | Account | Item | Memo | Amount |
|---|---|---|---|---|---|---|---|---|
| 2026-09 | 2026-09-15 | Cloudway Hosting | Bill | INV-44120 | 6310 Hosting and software | Production cluster, September | 12,800 | |
| 2026-09 | 2026-09-15 | Cloudway Hosting | Bill | INV-44120 | 6310 Hosting and software | Backup storage | 1,400 | |
| 2026-09 | 2026-09-04 | Ridgeline Contractors | Bill | B-7955 | 6005 Contractors | Data migration, 40 h | 5,200 | |
| 2026-09 | 2026-09-02 | Ridgeline Contractors | Bill Credit | VC-0214 | 6005 Contractors | Rework credit | -500 |
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,
TO_CHAR(t.trandate, 'YYYY-MM-DD') AS tran_date,
NVL(v.altname, v.entityid) AS vendor,
BUILTIN.DF(t.type) AS type,
NVL(t.tranid, t.transactionnumber) AS document,
BUILTIN.DF(tl.expenseaccount) AS account,
BUILTIN.DF(tl.item) AS item,
tl.memo AS memo,
tl.foreignamount * t.exchangerate AS amount
FROM transaction t
JOIN transactionline tl ON tl.transaction = t.id
JOIN entity v ON v.id = t.entity
WHERE t.type IN ('VendBill', 'VendCred')
AND t.posting = 'T'
AND tl.mainline = 'F'
AND tl.taxline = 'F'
AND NVL(tl.itemtype, 'x') NOT IN ('TaxGroup', 'TaxItem', 'Subtotal', 'Description', 'EndGroup')
AND t.trandate >= ADD_MONTHS(TRUNC(SYSDATE, 'MM'), -23)
ORDER BY t.trandate DESC, t.tranid04