Inventory Aging report
Use this report to track products sitting on your shelf for a long time. Based on the data available in this report, you can then prioritize using older products over newer ones to avoid letting stock expire on the shelves.
Example: Your center has 20 bottles of aloe vera shampoo and data in this report indicates that 5 bottles are 60 days old. To minimize wastage, you can now place those 5 bottles on the first row of your shelf so that therapists use them before they use the newer stock for services such as hair wash, or your front-desk will give those to guests in the case of a retail sale.
Note
Note: First, try to enable this report for your organization. Refer to the Enable Specific Reports article for this. However, there is a chance that this report is not available for your organization. If so, you will not be able to see the report in the Reports > List of Reports section. If this is the case, reach out to your Zenoti representative to enable this report for you.
At the organization or center level, click the Reports icon.
On the Reports page, search for and select the Inventory Aging report.
If the report has many columns, scroll horizontally to the right or left to view all columns.
To view specific data on the report, select the desired filters. For more information, refer to report features on Zenoti.
Click Refresh.
If you generate the report for over a year, click the Email button.
Important
All data displayed in this report is as of the current date.
This report follows the inventory management method of selling older inventory first, that is goods purchased first are sold first.
Column descriptions
Column | Description |
|---|---|
Center Name | Center where the product is logged in the inventory |
Product Name | Name of the product |
Product Code | The unique code that identifies the product |
Product Type | The Product type such as consumable, retail, or all |
UOM | The unit of measurement of the product For example, ml, gallon, oz, grams can be the unit of measurement. |
Vendor | Vendor with which the product is associated |
On-Hand Quantity | Total quantity of the product |
Age: 0-30 days | Number of items in inventory for less than a month |
Age: 31-60 days | Number of items in inventory between one and two months |
Age: 61-90 days | Number of items in inventory between two and three months |
Age: >90 days | Number of items in inventory for over three months |
Last Stock Inflow (days) | Number of days since the product stock was last replenished |
Sales/Consumption (Last 90 days) | Number of units of product sold or consumed in the last 90 days |
Avg Price (Perpetual) | Perpetual average cost of the product for the transaction. For more information and context on perpetual average cost, refer to the Perpetual average cost article. |
Pending Delivery Qty | Quantity of the product pending delivery (in progress orders) |
Alert Quantity | Minimum stock quantity of the product required until inventory is replenished If the quantity drops below this level, notifications are triggered |
Desired Quantity | Quantity of a product to be stocked for smooth inventory operations |
Suggested Quantity | Suggested quantity to order. This is the difference between desired quantity and the on-hand quantity. Example: Let’s say that the desired level of a product is 100 bottles, but you have only 30 bottles left in stock. In this case, the suggested quantity is 70 and you have to order 70 bottles to maintain the desired level. |