Build an open-PO report
An open-PO report answers two questions every morning: which purchase orders (POs) are late, and which ones are about to arrive. You build it once as a saved view on the Purchase Orders list. The view's dates are relative, so it stays current every day without changes.
The view below lists every open PO that isn't fully received and has an ETA (estimated time of arrival) on or before 7 days from today. That covers both halves in one list: overdue POs, and POs due today or in the next 7 days.
Before you begin
- You need access to Orders → Purchase Orders. To export, you need the Export purchase orders permission.
- The report relies on each PO's ETA. A PO with no ETA never appears in it. You can find those with the Available ETA filter set to Is Not Set.
- Read Save and pin table views if you haven't saved a view before.
Steps
- Go to Orders → Purchase Orders.
- If a view is open, click the ✕ on its chip to start from the unfiltered list.
- Click Advanced Filters.
- Leave the group set to all of the following.
- In the Statuses group, click Order Status, choose Is, and choose Open.
- Click Receipt Status, choose Is One Of, and choose Unreceived and Partially Received.
- In the Fulfillment group, click Available ETA, choose On or Before, choose Number of Days From Now..., and enter
7. - Click Apply Filters. Each condition shows as a chip under the toolbar.
- Click Columns and show the columns you want in the report, such as Supplier, Available ETA, Receipt, Total Qty, and Total.
- Click the Available ETA column header to sort the list by ETA, oldest first. The most overdue POs move to the top.
- Click Save as view on the views bar.
- Enter a Name, such as "Open POs: overdue + next 7 days".
- Leave Pin to the views bar on. Turn on Open this view by default if you want the list to open on this report.
- Click Save view.
What you'll see: the view's chip appears on the views bar. Under each date in Available ETA, a red label such as "3 days overdue" marks the late POs, and the others show how soon they're due.
Export the report
- With the view open, click Export.
- Under Records to export, choose Filtered results.
- Under Content, choose PO Summary for one row per PO, or PO with Line Items for one row per line.
- Under File format, choose XLSX (Excel) or CSV.
- Click Export.
The file holds the columns you have visible. See Exportable purchase order columns reference for what each mode includes.
How the dates work
- Number of Days From Now counts from today in your account's time zone, each time you open the view. With On or Before and
7, the view includes every ETA up to and including the 7th day from today, and every ETA in the past. - A PO counts as overdue when its ETA is before today. A PO due today appears in the report but isn't overdue yet.
- A PO leaves the report as soon as it's fully received, closed, or given a later ETA.
Split the report into two views
To keep late and upcoming POs apart, save two views instead of one:
- Overdue POs: in Advanced Filters, click Overdue? in the Fulfillment group and choose Overdue. It applies the same rules as above: open, unreceived or partially received, and an ETA before today.
- Arriving in the next 7 days: use steps 5 and 6 above, then click Available ETA, choose Within, choose The Next Number of Days..., and enter
7. This includes today and the next 7 days.
The Arriving This Week? filter covers this calendar week, Monday to Sunday, not the next 7 days. Use Available ETA for a rolling 7-day window.
Next steps
- Browse, filter, and manage the purchase orders list
- The purchase orders list: columns and filters
- Save and pin table views
- Supplier scorecard definitions: how overdue POs count against a supplier's on-time rate.