How To report on POs grouped by header vs by line item
The Purchase Order List can show one row per purchase order (the PO header) or one row per PO line. Use the PO view for totals by PO and vendor; use the PO Line view to see each part, its quantities, cost and dock date.Updated Nov 9 2026
Before you start
- Purchase Order List is under Purchasing > POs and is shown to users with the Purchasing, PurchasingOnly or AllPQuotes role.
-
View one row per PO
- Go to Purchasing > POs > Purchase Order List. The page is headed Purchase Orders.
- The list opens in the PO view: one row per purchase order, with chips Status is Open and Intercompany? is No in the filter search bar.
- Each row shows the PO's header details, such as PO #, Vendor, Entry Date, Status, # Lines and Total.
-
View one row per PO line
- On Purchasing > POs > Purchase Order List, click the filter search bar (Filter or search…) and choose View By.
- Pick PO Line and click Apply (n). A View By is PO Line chip appears.
- The list now has a row for every line, with Line # and PO # first, then line details such as Prcpart, Part, Description, Open Order Quantity, Quantity Received, Cost and Dock Date.
- In this view the Status chip applies to each line, so Status is Open shows the lines still waiting to be received, even on a PO where other lines are closed.
- For one row per PO again, click the View By is PO Line chip's ×, or set View By to PO again.
-
Choose the columns and export
- On either view, click the Edit columns icon (sliders) at the right-hand end of the column headings and switch on the columns you want. The PO Line view has its own, longer list of columns, and each view keeps its own choice.
- Click Export at the bottom of the list, next to Showing …. Cetec downloads po_list.xlsx with every row that matches your filters, one row per PO or per line as the list shows.