Overview
The PO Receiving Report shows one row per purchase order (PO) line: how much was ordered, how much was received and the difference. It updates as POs are received on the web, on mobile or through the Open API. Use it to find short, over and damaged receipts by PO, product or client.
đĄ To see each receipt on its own row (who received what, when and where), use Receiving History instead.
When to use it
You need to report receiving differences to a vendor or a client.
You want to check a POâs receiving progress line by line.
You want to see which lines had damaged quantities.
Prerequisites
At least one PO exists. Lines that havenât been received yet show a received quantity of 0.
Open the report
Go to Reports > Receiving > PO Receiving Report. Search by PO code or use the filters to narrow the list.
What each row shows
Column | What it shows | Example |
PO Code | The PO the line belongs to | PO-1001 |
Warehouse, Client | Where and for whom the PO is received | Main, Seed Client |
SKU, Product Name, Barcode | The product on the line | SKU-100 |
Pack Type | The pack type the line was ordered in | Case |
PO Quantity | The quantity ordered, in the lineâs pack type | 2 |
PO UOM Quantity | The quantity ordered, in base units | 12 (2 cases of 6) |
Received UOM Quantity | The quantity received so far, in base units. Cancelled receipts are taken off | 6 |
Receiving Difference | Received UOM Quantity minus PO UOM Quantity. Negative means short, positive means over-received | â6 |
Damaged Quantity | The part of the received quantity that was reported as damaged | 1 |
In the Excel export, PO Quantity, PO UOM Quantity and Receiving Difference are named Order Quantity, Order UOM Quantity and Receipt Difference.
How lines are counted
Each PO line is one row. Receiving a product in another pack type than its line adds the received quantity to that line, converted to base units. No new row is created.
Two lines of the same product stay separate rows when any of these differ: lot, expiry date, production date, pack type or LP. Lines that are exactly the same are merged into one PO line with the quantities added up, also when the second line is added later by editing the PO.
A line received in several lots stays one row, with the received quantities added up. This is the same whether the line has no lot or a different one. Each lot shows as its own receipt in Receiving History. If the line has a lot and the PO type has Lot Batch Number Match on, other lots canât be received.
A product that wasnât on the PO but was received (allowed by the PO type) gets its own row with a PO quantity of 0 and a positive difference.
Example: A PO orders 2 cases of 6 and 3 units of the same product, as two lines. After 1 case and 1 unit are received, the report shows the case line as 12 ordered, 6 received, â6, and the unit line as 3 ordered, 1 received, â2.
Export
Click Export to download the filtered report to Excel, up to 100,000 rows. The same data is also available through the Open API (GET /v3.1/Report/PurchaseOrderReceivingHistory).
Common questions
Why is the Receiving Difference negative? Less was received than ordered. For example, 3 received of 5 ordered shows â2.
Why does a line show a PO quantity of 0? The product wasnât on the PO and was received anyway, which adds a new line. See Receiving by Purchase Order (Mobile).
A receipt was cancelled. Does the report change? Yes. The received quantity goes down by the cancelled amount, and the difference changes with it.