Inventory Aging Report

This report shows the average age of your inventory. Use this report to see how long products stay in stock measured by time interval (0-30 days up to over 180 days). 


Prerequisite:


Data from this report can be exported in Excel, PDF or RTF format. 


Input:

LayoutSet to the Default layout. Allows selection of saved layouts, if any. 
Save Layout AsAllows saving of a layout for potential future use.
Reset LayoutResets 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. 


Output:

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. 


Fields
SKUProduct SKU.
ProductThe name of the product.
Batch #Batch or Serial Number.
Expiry DateExpiry Date of the batch.
Brand
Product brand.
Category
Product category.
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.
Data Headers
0-30 DaysQuantity purchased 30 or less days ago.
30-60 DaysQuantity purchased less than 60 days ago but more than 30 days ago.
60-90 DaysQuantity purchased less than 90 days ago but more than 60 days ago.
90-120 DaysQuantity purchased less than 120 days ago but more than 90 days ago.
120-150 DaysQuantity purchased less than 150 days ago but more than 120 days ago.
150-180 DaysQuantity purchased less than 180 days ago but more than 150 days ago.
Above 180 DaysQuantity purchased more than 180 days ago.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.