How do I read PO line reconciliation figures (shipped, billed, remaining) from the External API?
Last updated: August 16, 2026
PO line reconciliation figures — External API
The External V1 API's purchase order line-item object now exposes a full set of reconciliation quantities. These are the same figures the PO line-item grid displays, computed from the same source, so the API and the UI cannot drift apart.
Where line items appear
The same object is returned by three endpoints:
Endpoint | Notes |
|---|---|
| Paginated list across all POs; accepts line-level filters |
| Each PO includes an |
| Single PO with |
Units of measure — read this before comparing fields
A line carries two units. Subtracting a field in one unit from a field in the other produces a meaningless number.
Basis | What it is | Fields in this basis |
|---|---|---|
Ordered UOM | The unit the PO line was purchased in (cases, pallets, drums) |
|
Base UOM | The unit stock is tracked in (usually eaches) |
|
A line ordered as 10 cases of 12 has quantity 10 and quantity_ordered 120. Both are correct — they are the same purchase counted in two units.
Quantity fields
Field | Basis | Signed? | Description |
|---|---|---|---|
| Ordered | — | How much was ordered, in the ordered UOM |
| Base | — | The same order converted to the base UOM |
| Ordered | — | Total across all shipment lines linked to this PO line, converted per line |
| Base | — | Total across receipts, summed from individual receipt lines |
| Ordered | — | Total across all bill lines linked to this PO line (gross; drafts count; credits not netted) |
| Base | — | Open sales-order reservation (purchase-to-order). |
| Ordered | Yes |
|
| Mixed* | Yes |
|
| Base | Floored at 0 |
|
*remaining_to_receive spans two bases because quantity_received is in base UOM; treat it as approximate on lines where ordered and base units differ.
The two flooring rules
remaining_to_*is signed. Over-shipping is a supported flow; the negative is the number you need to spot variances.available_to_*is floored at 0. You cannot commit a negative quantity to a sales order.
Filtering
All five reconciliation fields are filterable on GET /purchase-orders/items using bracket notation (field[op]=value, operators: eq, neq, gt, gte, lt, lte, in, notin, contains, notcontains, set, notset).
Useful examples:
Lines shipped more than was ordered (over-shipments):
GET /external/api/v1/purchase-orders/items?remaining_to_ship[lt]=0
Lines still awaiting receipt on a specific PO:
GET /external/api/v1/purchase-orders/items?purchase_order_id=4471&remaining_to_receive[gt]=0
Received but not yet fully billed:
GET /external/api/v1/purchase-orders/items?quantity_received[gt]=0&quantity_billed[lt]=1
Field name change — action required if you integrated recently
The field quantity_remaining (first published 2026-08-06) has been renamed to available_to_allocate. The old name is not aliased and will not be returned. If you integrated against quantity_remaining in the past two weeks, update your code to use available_to_allocate.
The field received_quantity (published since 2024) is deprecated in favour of quantity_received. Both are still returned and carry the same value; prefer quantity_received in new code.
Related
PO shipment lines:
GET /external/api/v1/purchase-order-shipmentsBill variance:
GET /external/api/v1/bills/{id}/variance