Open purchase orders by expected date · Report library | HiScale Advanced Reports, native NetSuite reporting

Screenshot of the Open purchase orders by expected date report in HiScale Advanced Reports, filled with fictional sample data — Sample preview, fictional dataYour own figures appear after import.

About this report

Every open item line with quantity still to receive, on a purchase order that is Pending Receipt, Partially Received or Pending Billing/Partially Received. Each row gives the vendor, order date, expected date, days late, item, quantity ordered, received and remaining, and the open value in base currency. The expected date is the line's expected receipt date, or the order's due date when the line has none.

Sort by Expected date for the receiving schedule, or filter Days late above zero to chase vendors. The order number opens the purchase order.

Sample preview

Fictional figures in the shape you will see. Yours come from your account.

Purchase order	Vendor	Order date	Expected date	Days late	Item	Ordered	Received	Remaining	Open value
PO4410	Granite Components	2026-08-12	2026-09-10	14	Steel bracket 40mm	500	300	200	1,840
PO4431	Lakeshore Packaging	2026-08-28	2026-09-22	2	Shipping carton, large	2,000	0	2,000	3,100
PO4452	Granite Components	2026-09-09	2026-10-06	0	Hinge kit	750	0	750	4,687.50
PO4460	Eastfield Electronics	2026-09-15	2026-10-20	0	Controller board v3	120	0	120	10,560

The SuiteQL

This is the query each report runs. Read it, copy it, or change it after import.

Open purchase orders by expected date

SELECT t.id AS po__id,
       t.tranid AS po,
       NVL(v.altname, v.entityid) AS vendor,
       TO_CHAR(t.trandate, 'YYYY-MM-DD') AS order_date,
       TO_CHAR(NVL(tl.expectedreceiptdate, t.duedate), 'YYYY-MM-DD') AS expected_date,
       CASE WHEN NVL(tl.expectedreceiptdate, t.duedate) < TRUNC(SYSDATE)
            THEN TRUNC(SYSDATE) - TRUNC(NVL(tl.expectedreceiptdate, t.duedate)) ELSE 0 END AS days_late,
       BUILTIN.DF(tl.item) AS item,
       tl.quantity AS ordered,
       NVL(tl.quantityshiprecv, 0) AS received,
       tl.quantity - NVL(tl.quantityshiprecv, 0) AS remaining,
       (tl.quantity - NVL(tl.quantityshiprecv, 0)) * tl.rate * t.exchangerate AS open_value
  FROM transaction t
  JOIN transactionline tl ON tl.transaction = t.id
  JOIN entity v ON v.id = t.entity
 WHERE t.type = 'PurchOrd'
   AND t.status IN ('PurchOrd:B', 'PurchOrd:D', 'PurchOrd:E', 'B', 'D', 'E')
   AND tl.mainline = 'F'
   AND tl.taxline = 'F'
   AND tl.item IS NOT NULL
   AND NVL(tl.isclosed, 'F') = 'F'
   AND tl.quantity - NVL(tl.quantityshiprecv, 0) > 0
 ORDER BY NVL(tl.expectedreceiptdate, t.duedate), t.tranid