Skip to content

Purchase Order Report

Purchase Order Report is every order you have raised on a supplier over a period: what it was worth, what state it is in, and when it was supposed to arrive.

Open it from Add Report — see generating a report.

The Purchase Order Report filters: Order Date required, Delivery Date, and Show Column

Reports → Purchase Order Report

There are two date filters, and the difference between them is the whole point:

  • Order Date — required. When the order was raised.
  • Delivery Date — when it was due to arrive.

Filtering on Delivery Date with a range that has already passed, and reading the PO Status column, is how you find orders that should have landed and have not. That is the single most useful thing this report does.

The three totals: Invoice Total, Paid Amount and Due Amount

Reports → Purchase Order Report

Three figures head the report: what was ordered in the period, what has been paid against it, and what is still due.

The Purchase Order Report table: order reference, supplier, status, totals, and the order and delivery dates

Reports → Purchase Order Report

ColumnWhat it holds
Order ReferenceThe order’s own number.
Supplier NameWho it was raised on.
PO StatusNew, and the rest of the states an order moves through — see purchase orders.
Total AmountWhat the order came to.
Total Paid and Due AmountWhat has gone out against it, and what has not.
Order Date and Delivery DateWhen it was raised, and when it was due.

Status against delivery date is the pairing to read. An order still sitting at New with a delivery date in the past is the one to chase — either the goods never came, or they came and nobody recorded receiving them, and those are different problems. Receiving is what turns an order into stock; see receiving a purchase order.

Due Amount aggregated by supplier is the same figure the Supplier Report shows as one balance. Come here when you need to know which orders make it up.