01
About this report
Every posted vendor bill with an unpaid balance that is due within 30 days of today, overdue bills included. Each row shows the bill number, vendor, bill date, due date, days until due (negative when overdue), and the unpaid amount in the bill currency and in base currency.
Use it to plan the next payment run, or place it on a NetSuite dashboard as a portlet. The bill number opens the bill.
02
Sample preview
Fictional figures in the shape you will see. Yours come from your account.
| Bill | Vendor | Bill date | Due date | Days until due | Currency | Unpaid (bill currency) | Unpaid |
|---|---|---|---|---|---|---|---|
| B-7781 | Ridgeline Contractors | 2026-07-02 | 2026-08-01 | -54 | US Dollar | 2,250 | 2,250 |
| B-7902 | Ridgeline Contractors | 2026-08-10 | 2026-09-09 | -15 | US Dollar | 4,500 | 4,500 |
| PO-3319 | Pacific Office Partners | 2026-09-01 | 2026-10-01 | 7 | US Dollar | 3,120.40 | 3,120.40 |
| INV-44120 | Cloudway Hosting | 2026-09-15 | 2026-10-15 | 21 | US Dollar | 14,200 | 14,200 |
03
The SuiteQL
This is the query each report runs. Read it, copy it, or change it after import.
SELECT t.id AS bill__id,
NVL(t.tranid, t.transactionnumber) AS bill,
NVL(v.altname, v.entityid) AS vendor,
TO_CHAR(t.trandate, 'YYYY-MM-DD') AS bill_date,
TO_CHAR(t.duedate, 'YYYY-MM-DD') AS due_date,
TRUNC(t.duedate) - TRUNC(SYSDATE) AS days_until_due,
BUILTIN.DF(t.currency) AS currency,
t.foreignamountunpaid AS unpaid_fx,
t.foreignamountunpaid * t.exchangerate AS unpaid
FROM transaction t
JOIN entity v ON v.id = t.entity
WHERE t.type = 'VendBill'
AND t.posting = 'T'
AND t.foreignamountunpaid > 0
AND NVL(t.duedate, t.trandate) <= TRUNC(SYSDATE) + 30
ORDER BY NVL(t.duedate, t.trandate)04