How To Run a PO List Report
The Purchase Order List is Cetec's report of your purchase orders. Filter it to the POs you want, choose the columns, open any PO from it, and export it to a spreadsheet.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.
-
Open the list
- Go to Purchasing > POs > Purchase Order List. The page is headed Purchase Orders.
- The list runs as soon as it opens; there is no Submit button. It starts with two chips in the filter search bar, Status is Open and Intercompany? is No, so you see your open POs, one row per PO.
-
Filter the list
- Click the filter search bar (Filter or search…) and choose a filter, for example Vendor, PO, Buyer, Location, Prcpart (part number) or Type (All, Inventory, Non-Inventory or Outsource).
- Set the value, then click Apply (n). To set more than one filter, choose the next one before you apply. Until you apply, Cetec reminds you that the results don't include your pending changes; Discard throws them away.
- To filter by date, choose the date you want, such as Entry Date, Dock Date or Need Date, and pick a range (for example Last month) or type one.
- Applied filters show as chips in the filter search bar. To change one, click the chip's value, pick the new value and click Apply (n). To remove one, click its ×; the list refreshes at once. With three or more chips, some are folded into +n more; click it to see and remove them.
- To include closed POs, change the Status is Open chip to Closed, or to All (the Status chip then disappears).
-
Choose the columns
- Click the Edit columns icon (sliders) at the right-hand end of the column headings.
- Switch on the columns you want and switch off the ones you don't. The list changes as you click, and Cetec remembers your choice for this list the next time you open it.
- To hide one column, you can also click its heading and choose Hide column. The same menu sorts the list (Sort A → Z, Sort Z → A) and filters by that column (Filter by …). To change the column order, drag a heading.
-
Open a PO from the list
- In the PO # column, click the PO number. The PO opens.
- Use your browser's back button to return to the list with your filters still applied.
-
Export the list
- At the bottom of the list, next to Showing …, click Export.
- Cetec shows Exporting... and then downloads po_list.xlsx, an Excel file of every row that matches your filters, not just the page on screen.