Inventory aging report
Audience: Inventory managers and category buyers who need to identify slow-moving stock and plan reorders.
The inventory aging report helps you understand how long stock has been sitting in your centers. It shows stock levels alongside aging analysis, including desired levels, alert quantities, pending deliveries, last-quarter outflow, and inflow buckets for 30, 60, and 90 days. Use this report to identify slow-moving products, optimize reorder decisions, and reduce carrying costs.
This report is part of the modern reporting framework and uses the advanced grid view with full sorting, filtering, column resizing, and aggregation support.
Note: This report may not be available for all organizations. If the Inventory aging report does not appear on your reports dashboard, contact your Zenoti representative to confirm availability for your tenant.
Before you begin
- You must have the appropriate report permission to access this report.
Permission: Inventory Aging Report under the Inventory report permissions group β required to access the Inventory Aging report.
Run the report
- Navigate to Reports. The Reports Dashboard is the landing page.
- In the Inventory section, select Inventory Aging.
- The report opens in the V2 grid interface.
Filters
Configure the following filters to narrow the report data:
| Filter | Description |
|---|---|
| Centers | Select one or more centers to include. |
| Categories | Filter by product category. |
| Vendors | Filter by vendor. |
| Brands | Filter by product brand. |
| Subcategories | Filter by product subcategory. |
| Business units | Filter by business unit. |
| Products | Search for specific products. |
| Product types | Retail, consumable, or all. |
| Costing method | Select Perpetual Average Cost or FIFO (the two values of the StockCostingMethods enum). The Perpetual Average Cost and Stock Value columns recalculate based on the selected method. |
| On-hand quantity filter | Filter by stock availability (for example, only products with stock, only products below reorder level). |
| Search | Free-text search across product name and code. |
| Group column | Group results by a selected dimension. |
Key columns
The inventory aging report contains 22 columns covering stock levels, alert thresholds, and aging analysis. Key columns include:
| Column | Description |
|---|---|
| Product Name | The product name. |
| Product Code | The product's unique code. |
| Center | The center where the stock is held. |
| Category | The product's category. |
| On-hand Qty | The current on-hand quantity at the center (Floor + Storage when Unify Store and Floor is disabled; the unified value when enabled β see Configure inventory settings). |
| Desired Level | The configured target stock level for this product-center combination. |
| Alert Qty | The reorder minimum (low-stock alert threshold). |
| Pending Delivery Qty | Quantities in raised POs or TOs that have not yet been delivered. |
| Last Quarter Outflow | The total quantity consumed, sold, or transferred out in the last quarter. |
| Inflow (0β30 days) | Stock received in the last 30 days. |
| Inflow (31β60 days) | Stock received between 31 and 60 days ago. |
| Inflow (61β90 days) | Stock received between 61 and 90 days ago. |
| Stock Value | The total value of current on-hand stock. |
| Vendor | The primary vendor for this product. |
| Days Since Last Inflow | Number of days since the last stock inflow for this product. |
| Volume | The volume or size quantity of the product. |
| Unit of Measure | The unit of measurement for the product (ml, oz, pieces, etc.). |
| Product Type | Whether the product is Retail or Consumable. |
| Sub-Category | The product's sub-category. |
| Brand | The product brand name. |
| Business Unit | The business unit the product belongs to. |
| Perpetual Average Cost | The cost per unit based on the selected Costing method filter. When Perpetual Average Cost is selected, this column shows the running weighted average cost. When FIFO is selected, this column shows the FIFO-derived cost. |
Suggested reorder quantity
The Suggested reorder quantity formula is shared across the inventory module β it is used in Configure automatic orders (auto-PO generation) and surfaces here for slow-moving / overstock analysis. See Configure automatic orders for the definition.
In summary: Suggested Qty = Desired Level β (On-hand Qty + Pending Delivery Qty). If the result is zero, you have exactly the desired level on hand. If the result is negative, you have more stock than the desired level β review the row for slow-moving signals (low Last Quarter Outflow, high Days Since Last Inflow). Products older than 90 days do not appear in any of the three inflow buckets β those products have been sitting since at least the start of the previous quarter and are typically the highest-priority slow-mover candidates.
Report features
This report supports the standard V2 grid features (sort, filter, resize, reorder columns; pagination; column show/hide; flat-file CSV export). Numeric columns aggregate to sum totals in the footer. For framework-wide grid behaviors, see Inventory reports β Access V2 reports.
Tips
- Use the On-hand quantity filter to focus on products below their reorder level β these are the products that may need immediate reordering.
- Compare the Last Quarter Outflow against the On-hand Qty to identify products with stock levels that significantly exceed recent demand (potential overstock).
- Products with high Inflow (61β90 days) but low Last Quarter Outflow may indicate slow-moving inventory and warrant a manual review.