01
About this report
Sales orders that are Pending Fulfillment, Partially Fulfilled, Pending Billing/Partially Fulfilled or Pending Billing. Each row gives the customer, status, order date, ship date, days since the order date, and the order total in its own currency and in base currency.
Sort by Days open to find stuck orders, or filter on Status to separate orders that still have to ship from orders that only need an invoice. The order number opens the sales order.
02
Sample preview
Fictional figures in the shape you will see. Yours come from your account.
| Order | Order date | Customer | Status | Ship date | Days open | Currency | Total (order currency) | Total |
|---|---|---|---|---|---|---|---|---|
| SO10482 | 2026-08-03 | Harbor & Pine Co. | Sales Order : Partially Fulfilled | 2026-08-20 | 52 | US Dollar | 18,450 | 18,450 |
| SO10511 | 2026-08-19 | Brightline Dental Group | Sales Order : Pending Fulfillment | 2026-09-30 | 36 | US Dollar | 6,200 | 6,200 |
| SO10530 | 2026-09-02 | Maple Ridge Clinics | Sales Order : Pending Billing | 2026-09-10 | 22 | Canadian Dollar | 9,800 | 7,154 |
| SO10544 | 2026-09-11 | Summit Analytics LLC | Sales Order : Pending Fulfillment | 2026-10-01 | 13 | US Dollar | 2,375.50 | 2,375.50 |
| SO10551 | 2026-09-17 | Northgate Supply | Sales Order : Pending Billing/Partially Fulfilled | 2026-09-24 | 7 | Euro | 4,100 | 4,469 |
03
The SuiteQL
This is the query each report runs. Read it, copy it, or change it after import.
SELECT t.id AS order__id,
t.tranid AS order_no,
TO_CHAR(t.trandate, 'YYYY-MM-DD') AS order_date,
NVL(e.altname, e.entityid) AS customer,
BUILTIN.DF(t.status) AS status,
TO_CHAR(t.shipdate, 'YYYY-MM-DD') AS ship_date,
TRUNC(SYSDATE) - TRUNC(t.trandate) AS days_open,
BUILTIN.DF(t.currency) AS currency,
t.foreigntotal AS total_fx,
t.foreigntotal * t.exchangerate AS total
FROM transaction t
JOIN entity e ON e.id = t.entity
WHERE t.type = 'SalesOrd'
AND t.status IN ('SalesOrd:B', 'SalesOrd:D', 'SalesOrd:E', 'SalesOrd:F', 'B', 'D', 'E', 'F')
ORDER BY t.trandate04