Reporting Explained: Inventory On Hand Report
Yellow Dog Software |
Reporting Explained
Inventory On Hand Report
Admin or power user · Yellow Dog Inventory 2026
Why It's Important
Use the Inventory On Hand report to see how much inventory you have available at a specific date and time.
Where
Standard Reports > Inventory > On Hand > By Item
You can generate the report in multiple formats:
- By Dimension
- By Level
- By Store
- By Style
How It Works
The report shows the on-hand quantity for each item at the selected date and time.
It also includes additional information such as:
- Total cost of items on hand
- Total retail value
- Current quantity on order
- Last received or invoiced cost
Step By Step
Generate the Report
- Go to Reports > Standard Reports.
- Select Inventory > On Hand > By Item.
- Set the Date/Time filter. By default, it is set to Now, but you can choose any date and time.
- Apply additional filters as needed.
- Click Generate.
Additional Filters
You can filter the report by:
- Stores
- Levels
- Vendors
- Evergreen
- Dimensions
- Combine Stores
- Include or exclude inactive items
- Only show inactive items
- Only show items with negative on-hand
- Include or exclude items with zero on-hand
Key Columns
| Column | Description |
| Primary Vendor | The vendor marked as the primary vendor when an item has multiple vendors. |
| Total On Hand | The quantity of the item on hand at the selected date and time. |
| Total On Hand Cost | The on-hand quantity multiplied by the calculated item cost at the selected date and time. |
| Total On Hand Retail | The on-hand quantity multiplied by the item's retail price at the selected date and time. |
Best Practices
When a Cost Looks Off
- If Total On Hand Cost appears incorrect or inflated, run the Troubleshooting > Item OnHand Calculated Cost report. This report breaks down the calculated costs currently contributing to the item's total on-hand cost, helping you pinpoint where an unexpected or inflated cost originated.
Related Articles
Last reviewed: September 2026