01
About this report
Every purchase order in Pending Supervisor Approval. Each row gives the vendor, the employee named on the order as Requested by, order date, days waiting, memo, and the total in the order currency and in base currency.
Sort by Days waiting to clear the oldest first. The order number opens the purchase order.
02
Sample preview
Fictional figures in the shape you will see. Yours come from your account.
| Purchase order | Vendor | Requested by | Order date | Days waiting | Memo | Currency | Total (order currency) | Total |
|---|---|---|---|---|---|---|---|---|
| PO4466 | Eastfield Electronics | Priya Natarajan | 2026-09-16 | 8 | Q4 controller stock | US Dollar | 21,400 | 21,400 |
| PO4471 | Lakeshore Packaging | Tom Okafor | 2026-09-19 | 5 | US Dollar | 3,100 | 3,100 | |
| PO4475 | Nordic Tooling AB | Tom Okafor | 2026-09-22 | 2 | Replacement dies | Euro | 6,800 | 7,412 |
03
The SuiteQL
This is the query each report runs. Read it, copy it, or change it after import.
SELECT t.id AS po__id,
t.tranid AS po,
NVL(v.altname, v.entityid) AS vendor,
BUILTIN.DF(t.employee) AS requested_by,
TO_CHAR(t.trandate, 'YYYY-MM-DD') AS order_date,
TRUNC(SYSDATE) - TRUNC(t.trandate) AS days_waiting,
t.memo AS memo,
BUILTIN.DF(t.currency) AS currency,
t.foreigntotal AS total_fx,
t.foreigntotal * t.exchangerate AS total
FROM transaction t
JOIN entity v ON v.id = t.entity
WHERE t.type = 'PurchOrd'
AND t.status IN ('PurchOrd:A', 'A')
ORDER BY t.trandate