Inventory Aging Report shows how long products stay in stock by time intervals. Use this report to see which products have a high turnover rate and low turnover rate. See how long products stay in stock measured by time interval (0-30 days up to over 180 days) as of the current date.
NOTE: Inventory Age is measured from stock received date, not purchase date. In the case of finished goods, inventory age is measured from the assembly date. If stock is moved during a Stock Transfer, the transfer date will be the new received date.
Data from this report can be exported in Excel, PDF or RTF format.
Table of Contents
|Layout||Set to the Default layout. Allows selection of saved layouts, if any.|
|Save Layout As||Allows saving of a layout for potential future use.|
|Reset Layout||Resets layout to the default layout or selected saved layout.|
Select Apply Filter to set filter fields for the report and Update to refresh the output with any new changes. See Managing DEAR Reports - Filtering Reports for more detailed information about using filters.
The following output fields are available for this report. You may have to open the More Fields dropdown menu to add some of them to your report.
|Product||The name of the product.|
|Batch #||Batch or Serial Number.|
|Expiry Date||Expiry Date of the batch.|
|Tags||Comma-separated product tags.|
|Unit||Product unit of measure.|
|Bin||Bin where stock is located within Location.|
|Location||Location where stock is stored.|
|Product Additional Attribute 1-10||Values of product additional attributes.|
|0-30 Days||Quantity received 30 or less days ago.|
|30-60 Days||Quantity received less than 60 days ago but more than 30 days ago.|
|60-90 Days||Quantity received less than 90 days ago but more than 60 days ago.|
|90-120 Days||Quantity received less than 120 days ago but more than 90 days ago.|
|120-150 Days||Quantity received less than 150 days ago but more than 120 days ago.|
|150-180 Days||Quantity received less than 180 days ago but more than 150 days ago.|
|Above 180 Days||Quantity receiveed more than 180 days ago.|
Can inventory value be added to "Inventory Aging" report?
Unfortunately, as per the current design of the DEAR value cannot be added to the report Inventory Aging.
There is no report in which you can have both Inventory aging and the value of the inventory. As a work around, you may export Inventory Movement Details to Excel and use VLOOKUP function against the aging report. This can be requested on our feature request forum for consideration for future development releases.
When I run the inventory aging report, the aging appears to reset when stock item is moved from one location to another. I want the report to show aging from the date the stock was acquired to present regardless of movement between locations. Is there a way to modify the report to achieve this?
Unfortunately, this is the limitation when using stock transfer. The stock transferred to a new location will have the transfer date as new date received. As a workaround, use the Inventory Movement Details report instead to get the receive date in the PO. You could filter the report to exclude Stock Transfers and Stock Adjustments to be able to get actual inventory aging.
Is it possible to change the "aging" groups? We are in the fresh food business, and we are interested to know how many hours/days our inventory is. ie: 1 day 2 days 3 days ...
Unfortunately it is not possible to change the aging groups. Days 1,2 and 3 will fall into column range of 0-30 days, however you could provide this as feature request in the forum.
Is there a way to generate the Inventory Aging Report as at a certain date?
Unfortunately, no. Once you pull up the Inventory Aging Report, it pulls up the current age status of the products. This can be added as a feature request in the forum. You can run Inventory Movement Details report to view product movement by time interval.
Still no answer to your question? Please do not hesitate to get in touch with DEAR support.