Reporting Explained: Inventory Aging
Use this report to understand how long inventory has been in stock. It helps you:
- Identify slow-moving or excess inventory
- Reduce waste and spoilage
- Improve purchasing decisions
Standard Reports>Inventory>Aging
The Inventory Aging report groups on-hand inventory by the length of time it has been in stock.
- All values are calculated based on the selected As Of Date
- Aging is grouped into time buckets (for example, 0–89 days, 90–179 days)
- Results can be summarized at different levels
You can run the report by:
- Department
- Department by Quarter
- Item
- Item by Quarter
- Store
- Vendor
Generate the report
- Go to Reports > Standard Reports
- Open Inventory > Aging
- Select a report version
- Select the As Of Date
- Apply filters as needed
- Click Generate
Filters
-
As Of Date (Required)
Defaults to current date/time. You can select a specific date, previous end of day, or previous end of month -
Stores (Optional)
Includes all stores by default -
Levels (Optional)
Filters by item level -
Vendors (Optional)
Filters by vendor -
Evergreen Items (Optional)
Includes all items by default
| Column | Description |
|---|---|
| Total On Hand | Total quantity currently in stock |
| Total On Hand Extended Cost | Total cost of current inventory |
| Total On Hand Retail | Total retail value of current inventory |
| Cost 0–89 | Cost of items received within the last 0–89 days |
| Cost 90–179 | Cost of items received within the last 90–179 days |
| Cost 180–269 | Cost of items received within the last 180–269 days |
| Cost 270–359 | Cost of items received within the last 270–359 days |
| Cost 360–449 | Cost of items received within the last 360–449 days |
| Cost 450–539 | Cost of items received within the last 450–539 days |
| Cost 540–629 | Cost of items received within the last 540–629 days |
| Cost 630–719 | Cost of items received within the last 630–719 days |
| Cost 720+ | Cost of items in stock for more than 720 days |
Related Articles
Reporting Explained: Inventory Chart on Hand by Selected Dimension
Use this report to visualize on-hand inventory totals by dimension. It helps you: Compare inventory across categories (for example, size, type, or location) Identify concentration of inventory value Support purchasing and inventory balancing ...Reporting Explained: ReOrder
Reporting Explained: Re-Order Business Need: This report will show items that are either at or below the re-order point assigned, and include the quantities needed to bring the items back up to Par. How it works: To best utilize this report users ...Reporting Explained: Summary By Period
The Inventory Summary by Period report provides an overview of inventory activity for a selected date and time range. It shows the starting inventory cost, all inventory movements during the period, and the ending inventory cost. Reports > Standard ...How To: Use Aging Reports & Evergreen Status?
Aging reports show how long items have been in stock. This helps you identify inventory that may need to be used or moved soon. You can mark items as Evergreen if they do not expire or are always stocked, such as: Brand standard items Paper goods ...Reporting Explained: Inventory Adjustments
Use this report to review all manual adjustments made to inventory over a selected period. It helps you: Track waste, damage, and spoilage Monitor production and non-standard inventory activity Validate that all adjustments are recorded before ...
Popular Articles
How To: Find Your Yellow Dog Inventory Version
Understanding which version of Yellow Dog Inventory you're using is essential when exploring new features, as some enhancements and functionalities are specific to certain versions. All client types can benefit from knowing their Yellow Dog Inventory ...Feature Overview: Par & Re-Order Points
Par levels and reorder points help streamline purchasing in Yellow Dog. Par level is the ideal quantity to keep on hand. Reorder point is the minimum quantity that triggers reordering. You can update par and reorder points in the following locations: ...Tips & Tricks: How do I download and install drivers for my Zebra Printer?
**As a note: Admin rights will be required to complete this task. If you do not have admin rights on your PC, please contact your IT for assistance** ZD410 Desktop Printer Support Site 1. Navigate to Drivers: 2. Select Zdesigner V. 5 Driver for ...How To: Swap the On-Hand/Parent Size (Edit Base Unit)
When managing items with multiple sizes, it’s essential to configure them correctly. The on-hand/parent size should always represent the base unit or smallest measurement, while additional sizes should be created for purchasing or counting sizes. If ...FAQs: What are Bins?
Question: What are Bins? Answer: Bins are optional location identifiers that specify exactly where an item is stored. You don’t need to create bins in advance. You can assign them: In the Stores tab of the item editor Through a Balto import Bins ...