Purchase orders by item report

Use the Purchase orders by item report in Menu > Reports to review purchase order item-line quantities and amounts grouped by item for a selected date range. Expense lines are excluded because they do not contain an item.

Run the report

  1. Open Menu > Reports. In Search by report or description, enter the report name and press Enter.
  2. Select Purchase orders by item.
  3. Select Change date range to choose the purchase order date range. The default is Last 30 days.
  4. Optionally filter by Item type or Receiving location.
  5. Expand an item to review its purchase order date, purchase order, memo, rate, total quantity, and total amount.
  6. Select Export as Excel (.xlsx) to export to Excel, or open More actions and select Export as PDF.

How the report is calculated

The report groups purchase order item lines by item for purchase orders in the selected date range. Quantity is the sum of the ordered line quantities, and Amount is the sum of the purchase order line amounts. Expense lines are excluded because they do not contain an item.