Aged Inventory Analysis by Tree Report
This report prints inventory on hand quantities, unit costs, and aged values. Inventory is aged using the dates for transactions that increase
Note: The report excludes non-diminishing items.
Header Details
- Report process date and time
- Page number
Line Details
These details display for each item:
- Item code
- Item description
- Location (if printing at a location level instead of a master level)
- Unit of measure
- Closing quantity (current year)
- Unit cost (based on costing method)
- Current value
- If Yearly Break is selected,
inventory is aged in years:
- 1 Year value
- 2 Years value
- 3 Years value
- 4 Years value
- If Yearly Break is not
selected:
- 60 days value
- 90 days value
- 120 days value
- 120 days+ value
The sum of the last five columns always be equal to the Quantity on hand x Unit cost.
If the option to Print in Detail is not selected, item codes and descriptions do not appear in the report. If the Print Lines option is selected, all individual transactions display. Otherwise, only a summary line displays for each item.