Inventory orders report
Audience: Inventory manager, center admin
The inventory orders report shows purchase order (PO) and transfer order (TO) history with ordered and delivered quantities and values. Use this report to track order fulfillment, identify pending deliveries, and review procurement and transfer activity over time.
This is a legacy report available under the classic reporting framework. For deeper retrospective analysis with multi-method costing and per-transaction detail, use the V2 reports under the Inventory report permissions group.
When to use this report vs. Manage purchase orders / Manage transfer orders: The Manage pages are operational β they let you raise, edit, and receive orders against today's working set. This report is for retrospective analysis and export across a date range, with both order types in one view.
Important: The date filter anchors on the date the PO or TO was raised (
Order Date), not the delivery date. Delivered quantities shown reflect deliveries recorded against orders raised in the selected period. Voided or deleted orders are excluded; orders in any workflow status that were raised in the period β including closed orders β are included.
On this page
- Before you begin
- Run the report
- Filter reference
- Column reference
- Order status values
- Worked example
- Tips
- Troubleshooting
- Related articles
Before you begin
- Enable the report for your organization under Configuration > Reports > List of reports.
Permission: Orders History under View Inventory Reports in the Inventory Manager section of the security role β Required to access the Inventory orders report.
Run the report
- Select the center for which you want to run the report.
- Navigate to Reports > Inventory.
- Select the Orders report.
- Set the date range, Order Type (single dropdown β choose
Purchase Order,Transfer Order, orBoth), and any additional filters from the Filter reference. - Click Refresh.
To export the report, click the Excel or CSV icon.
Note on date range: The date filter anchors on Order Date (the date the PO or TO was raised), not delivery date. Voided and deleted orders are excluded. Orders in any workflow status that were raised in the selected period β including closed orders β are included.
Filter reference
| Filter | Values | Description |
|---|---|---|
| Date range | From / To dates | Filters by Order Date (the date the PO or TO was raised). Delivered quantities shown are those recorded against orders raised in this period. |
| Order Type | Purchase Order / Transfer Order / Both | Single-select dropdown. Both returns both PO and TO rows in one result set. |
| Category | Configured product categories | Limits results to products in the selected category. |
| Sub-Category | Configured sub-categories | Further narrows the category filter. |
| Vendor | Configured vendors | Limits PO rows to the selected vendor. TO rows show blank for this column because transfer orders are between centers, not between vendor and center. |
| Search | Free-text | Filters rows by product name or product code substring. |
Note: Status is not exposed as a filter in this report. To filter by status, use the Tips below for status-driven follow-up workflows.
Column reference
| Column | Type | Description |
|---|---|---|
| Order Number | Identifier | The unique PO or TO number. |
| Date | Date | The Order Date (when the order was raised). |
| Order Type | Enum | Purchase Order or Transfer Order. |
| Status | Enum | The current order status. See Order status values. |
| Vendor | Text | For POs: the vendor on the order. For TOs: blank. |
| Source Center | Text | For TOs: the dispatching center. For POs: blank. |
| Destination Center | Text | For TOs: the receiving center. For POs: the receiving center is shown under the report's center selection above. |
| Ordered Quantity | Number | The quantity originally ordered. |
| Ordered Value | Currency | Ordered quantity Γ the ordered price captured per line when the PO or TO was raised. For POs, this defaults from the product's configured purchase price but is editable per line at the time of order. |
| Delivered Quantity | Number | The quantity actually delivered (cumulative across partial deliveries). |
| Delivered Value | Currency | Received quantity Γ the delivered price recorded at the time of delivery. This may differ from Ordered Value when the vendor invoice price differs from the price entered at order time. |
| Pending Quantity | Number | Ordered Quantity β Delivered Quantity. Decreases with each partial delivery; reaches 0 on full delivery. |
Costing note: Ordered Value and Delivered Value use different price sources. Ordered Value is the per-line price captured when the order was raised; Delivered Value is the per-line price recorded when the delivery was received. Reconciling these two columns against your vendor invoices helps identify price variances. For deeper costing analysis (Perpetual Average Cost, FIFO β First In First Out), use the V2 Cost of goods report.
Order status values
The Status column reflects different enumerations depending on order type.
Purchase orders:
| Status | Meaning |
|---|---|
| Created | The PO record exists but has not yet been raised to the vendor. |
| Raised | The PO has been submitted to the vendor; awaiting receipt. |
| Updated | The order details have been modified after the initial recording β typically through a Modify Delivery action. |
| Partially delivered | One or more partial deliveries have been recorded; more is expected. |
| Delivered | All ordered quantities have been received. |
| Reconciled | The PO is reconciled and closed; no further deliveries can be recorded. |
Transfer orders:
| Status | Meaning |
|---|---|
| Created | The TO record exists but has not yet been raised. |
| Raised | The TO has been raised; awaiting dispatch. |
| Updated | The order details have been modified after the initial recording β typically through a Modify Delivery action. |
| In Transit | Stock has been dispatched from the source center; awaiting receipt at the destination center. |
| Partially delivered | One or more partial deliveries have been recorded. |
| Delivered | All dispatched quantities have been received. |
Worked example
A center wants to identify pending vendor deliveries for the last 30 days.
- Select Orders report under Reports > Inventory.
- Set Date range: last 30 days.
- Set Order Type: Purchase Order.
- Click Refresh.
Sample result:
| Order Number | Date | Status | Vendor | Ordered Qty | Ordered Value | Delivered Qty | Delivered Value | Pending Qty |
|---|---|---|---|---|---|---|---|---|
| PO-1042 | 2026-04-15 | Partially delivered | AcmeSupply | 100 | $500.00 | 60 | $306.00 | 40 |
| PO-1051 | 2026-04-22 | Raised | NorthBeauty | 50 | $250.00 | 0 | $0.00 | 50 |
| PO-1056 | 2026-04-25 | Delivered | AcmeSupply | 30 | $150.00 | 30 | $153.00 | 0 |
| PO-1063 | 2026-04-28 | Partially delivered | NorthBeauty | 80 | $400.00 | 25 | $128.75 | 55 |
Note that for PO-1056, the Delivered Value ($153.00) differs slightly from the Ordered Value ($150.00) because the vendor's invoice reflected a higher per-unit price at delivery. The inventory manager can review this variance before reconciliation.
The pending-quantity total (40 + 50 + 55 = 145 units) gives the inventory manager a follow-up list for vendor reminders. After exporting the rows for Status = Partially delivered or Raised, the team contacts AcmeSupply about PO-1042 and PO-1063, and NorthBeauty about PO-1051.
Tips
- Track pending deliveries. Export the report and filter rows where
Status = Partially deliveredorRaisedto identify orders requiring vendor follow-up. The Pending Quantity column shows how many units remain outstanding per order. - Reconcile ordered vs. delivered value. Compare the Ordered Value and Delivered Value columns to identify price variances between what was ordered and what the vendor invoiced at delivery. Variances greater than your tolerance threshold may require a vendor credit note or a price adjustment before reconciliation.
- Vendor catalog orders are included. POs created via vendor catalog integration (Aveda, NeillCorp, SuperCenter) appear in this report alongside manually raised POs and are distinguished by the Vendor column. See Configure vendor catalog integration.
Troubleshooting
| Issue | Cause | Resolution |
|---|---|---|
| Report shows no rows after enabling | The org-level List of reports toggle was recently enabled; the underlying data view may not have refreshed yet. | Wait 1β2 minutes and click Refresh. If still empty, verify orders exist in the date range via Inventory > Orders. |
| Vendor column is blank for all PO rows | The products on the PO have no default vendor mapped at this center. | Assign a default vendor on each product's center-level configuration, then re-raise the PO. |
| Permission denied | The user role lacks Orders History under View Inventory Reports. | Confirm the role has that check box under View Inventory Reports in the Inventory Manager section of the security role. |
| Totals do not match the Inventory > Orders listing | The Inventory > Orders listing reflects today's working set filtered by current status; the report reflects orders raised within the selected date range. | Align the Inventory > Orders filter to the same date range, or accept that the report includes closed and historical orders the listing may not show. |
| Delivered Value differs from Ordered Value | The vendor's invoice price at delivery was different from the price entered when the order was raised. | Review the per-line delivered price on the order detail page. If the master purchase price should be updated, use the price-difference prompt on delivery. See Receive deliveries. |