Purchase Order Item Report
Where the Purchase Order Report gives you one row per order, Purchase Order Item Report opens the orders up and gives you one row per line.
That is the difference between knowing you spent a certain amount with a supplier and knowing what you actually bought.
Open it from Add Report — see generating a report.
What it asks for
Section titled “What it asks for”
Reports → Purchase Order Item Report
- Order Date — required.
- Delivery Date — when the goods were due.
- Purchase Order — one order or several, when you want the lines of a particular order.
- Inventory Item — a single item, which is the filter that turns this into a buying history.
- Show Column — which of the nine columns to carry.
What comes back
Section titled “What comes back”The heading gives the Order Reference Number and the Total Amount behind it.
Reports → Purchase Order Item Report
| Column | What it holds |
|---|---|
| Item Name and Description | What was ordered. |
| Order Date | When it was ordered. |
| Qty | How many. |
| Rate | The price per unit on this order. |
| UOM | The unit it was bought in — see inventory settings. |
| Discount | What came off. |
| Tax Amount | The tax on the line. |
| Total Amount | What the line came to. |
| Status | Whether the line has been received — Not Received until it is. |
Reading it
Section titled “Reading it”Filtered to one Inventory Item, this is a buying history. Every time you have ordered that part, with the rate you paid each time, in date order. A rate that has crept up over four orders is a conversation with the supplier — and it is not visible anywhere else in the system, because the item’s own record carries one standing supplier cost rather than what you actually paid each time.
Filtered to Not Received, it is the shortfall. Part-delivered orders are the awkward case: the order looks handled, and one line on it never came. This is where that line shows up.
That matters beyond the paperwork, because an item’s stock only rises when the order is received — see receiving a purchase order. A line stuck at Not Received is stock you think is coming and that the Current and projected stock report is not counting.
Related
Section titled “Related”- Purchase Order Report — the same orders, one row each.
- Receiving a purchase order — what turns a line into stock.
- The item page — where an item’s standing supplier cost is kept.