The Reorder Analysis Report helps identify purchased parts that may need replenishment based on net available inventory and reorder point.
What this report is for
Use Reorder Analysis to review active inventory items with a vendor code other than ESTORE that may need reorder.
This report does not create purchase orders. It supports purchasing review.
Screen path
Dashboard > Inventory > Reports > Reorder Analysis
Filters and actions
| Control | What it does |
|---|---|
| Search | Filters by part number, description, or vendor code. |
A-Z |
Sorts by vendor and part number ascending. |
Z-A |
Sorts by vendor and part number descending. |
Reorders |
Sorts parts flagged for reorder first. |
Copy for Excel |
Copies filtered report rows to the clipboard. |
Report columns
| Column | What it shows |
|---|---|
Vendor |
Vendor code on the inventory part. |
Part Number |
Inventory part number. |
Description |
Inventory description. |
UOM |
Stocking unit of measure. |
On Hand |
Total quantity on hand across lots. |
On Order |
Quantity on order. |
Required |
Quantity required. |
Net Available |
On Hand plus On Order minus Required. |
Reorder Point |
Reorder point from item setup. |
Order Qty |
Standard order quantity from item setup. |
Lead (days) |
Lead time from item setup. |
Avg Monthly |
Average monthly usage from item setup. |
Months Worth |
Net Available divided by average monthly usage, when usage is greater than zero. |
Reorder? |
Shows yes when Net Available is below Reorder Point. |
What happens behind the scenes
PAX reads active inventory items where the vendor code is populated and is not ESTORE.
Net Available is calculated as on-hand quantity plus on-order quantity minus required quantity.
The report flags yes when Net Available is less than Reorder Point.
Running or copying the report does not create purchase orders, update reorder points, or change inventory.
Troubleshooting
A purchased item is missing
Likely cause: The item is inactive, has vendor code ESTORE, has no vendor code, or does not match the current search filter.
Safe fix: Clear search and review the part setup.
Contact support if: An active purchased item should appear but does not.
Reorder flag looks wrong
Likely cause: On hand, on order, required, or reorder point setup may need review.
Safe fix: Review the part setup and open demand/supply before creating a purchase order.
Contact support if: Quantity fields do not match the underlying records.