The Open Orders by Part Number report shows open inventory demand by part, including on-hand quantity, available quantity, open order count, and open quantity.
What this report is for
Use Open Orders by Part Number to review customer demand for inventory parts on open and partially shipped Sales Orders.
This report helps Sales, Shipping, Manufacturing, and Inventory users see which parts are still needed to fulfill open customer demand.
Screen path
Dashboard > Sales > Reports > Open Orders by Part Number
Dashboard > Shipping & Receiving > Reports > Open Orders by Part Number
Controls and actions
| Control | What it does |
|---|---|
| Search | Searches by part number or description. |
Expand All |
Opens order-line detail for all listed parts. |
Collapse All |
Closes expanded detail. |
Copy for Excel |
Copies the summary or expanded detail to the clipboard. |
| Part row | Expands or collapses order-line detail for one part. |
If no parts are expanded, Copy for Excel copies the summary. If one or more parts are expanded, it copies detail rows for expanded parts.
Report columns
Summary rows show:
| Column | What it shows |
|---|---|
Part Number |
Inventory part number. |
Description |
Inventory description. |
Product Line |
Inventory product line. |
On Hand |
Current on-hand quantity. |
Available |
Current available quantity. |
Orders |
Count of open or partially shipped orders with open quantity for the part. |
Total Open Qty |
Total open quantity across matching order lines. |
Expanded detail rows show:
| Column | What it shows |
|---|---|
Order # |
Sales Order number. |
Customer |
Customer name and customer code. |
Customer PO |
Customer purchase order number. |
Order Date |
Sales Order date. |
Required Date |
Required date on the order. |
Planned Ship |
Planned ship date on the order line. |
Ordered |
Ordered quantity. |
Shipped |
Quantity already shipped. |
Open Qty |
Remaining open quantity. |
Unit Price |
Sales Order line unit price. |
Ext. Cost |
Open quantity multiplied by unit price as shown by the report. |
What happens behind the scenes
PAX reads Sales Order lines joined to Sales Order headers, customers, and inventory.
The report includes only:
- Sales Orders with status
OpenorPartially Shipped. - Orders that are not deleted.
- Inventory lines.
- Lines with open quantity greater than zero.
The report does not include non-inventory order lines, closed orders, deleted orders, fully shipped lines, or lines with zero open quantity.
Running, expanding, or copying the report does not reserve inventory, ship inventory, edit orders, or update customer records.
Troubleshooting
A part is not listed
Likely cause: The part has no open inventory order lines, or the search term filters it out.
Safe fix: Clear the search field and confirm the order line is inventory type with open quantity.
Contact support if: An open inventory line should appear but does not.
Order detail is missing for a part
Likely cause: The detail request did not load or the part no longer has matching open order lines.
Safe fix: Collapse and expand the part again, or close and reopen the report.
Contact support if: Detail repeatedly fails for the same part.
Available quantity does not cover open quantity
Likely cause: Customer demand exceeds current available inventory.
Safe fix: Review inventory availability and the related order lines before promising shipment dates.
Contact support if: Inventory quantities appear incorrect across inventory and order screens.