Overview
Inventory status reports answer questions such as: Which items exist, what is on hand, which items are below reorder level, which stock is aging, and which products have become dormant.
Good approach: Use item and stock-status reports for the current position, then move to aging or dormant-stock reports when you want to review stock quality and movement risk.
Reports Covered
| Report | Use It For |
|---|---|
| Items List Report | Review the main product list and item reference information. |
| Items Cost List Report | Review item cost information. |
| Items Price List Report | Review item selling prices. |
| Items by Category Report | Review items grouped by category. |
| Items Stock Status List / Items Stock Status List by Store | Review on-hand position overall or by store. |
| Items Stock Status History Report | Review how stock status changed over time. |
| Items Reorder Level Report / Items Reorder Level by Store Report | Identify items that should be reordered. |
| Inventory Aging Summary Report | Review how old the current stock is. |
| Inventory Aging and Turnover Report | Review stock age together with turnover performance. |
| Dormant Inventory Report | Identify stock that is not moving. |
| Pending Items Report / Pending Items Details Report | Review items with pending quantity or pending fulfillment position. |
Common Filters
| Field Or Option | What It Means |
|---|---|
| Item / Category | Focus the report on selected products or product groups. |
| Store | Review stock at a specific location. |
| Show Inactive Items | Include inactive products when a full stock review is needed. |
| Show Positive / Zero / Negative Quantity | Control which stock positions appear in stock-status reports. |
| Calculate Subunits / Decimal Subunits | Useful where items are managed in subunits and decimal-based quantities. |
Best Practice
- Use stock-status reports for operational control.
- Use reorder-level reports for replenishment planning.
- Use aging and dormant-stock reports for slow-moving stock review.
- Use by-store reports whenever stock responsibility is branch-based.
Important: If on-hand quantities look incorrect, review inventory movement and transaction reports before changing master data.