Admin or power user · Yellow Dog Inventory 2026
WHY IT'S IMPORTANT
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
WHERE
Standard Reports > Inventory > Aging
HOW IT WORKS
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–29 days, 30–59 days)
• Results can be summarized at different levels
You can run the report by:
• Department
• Department by Quarter
• Item
• Item by Quarter
• Store
• Vendor
STEP BY STEP
Generate the Report
1. Go to Reports > Standard Reports.
2. Open Inventory > Aging.
3. Select a report version.
4. Select the As Of Date.
5. Apply filters as needed.
6. 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.
KEY COLUMNS
|
COLUMN |
DESCRIPTION |
|
|
|
Total On Hand |
Total quantity currently in stock |
|
|
|
Total On Hand Retail |
Total retail value of current inventory |
|
|
|
Total On Hand Extended Cost |
Total cost of current inventory |
|
|
|
Cost 0–29 |
Cost of items received within the last 0–29 days |
|
|
|
Cost 30–59 |
Cost of items received within the last 30–59 days |
|
|
|
Cost 60–89 |
Cost of items received within the last 60–89 days |
|
|
|
Cost 90–119 |
Cost of items received within the last 90–119 days |
|
|
|
Cost 120–149 |
Cost of items received within the last 120–149 days |
|
|
|
Cost 150–179 |
Cost of items received within the last 150–179 days |
|
|
|
Cost 180–364 |
Cost of items received within the last 180–364 days |
|
|
|
Cost 365+ |
Cost of items in stock for more than 365 days |
|
|
|
Note: The same age buckets shown above for Cost are also available for Quantity and Retail. |
||
Last reviewed: August 2026 · Applies to: Yellow Dog Inventory 2026