Reporting Explained: Inventory On Hand Report
Use the Inventory On Hand report to see how much inventory you have available at a specific date and time.
Standard Reports > Inventory > On Hand > By Item
You can generate the report in multiple formats:
- By Dimension
- By Level
- By Store
- By Style
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
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
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. |
Related Articles
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 ...Reporting Explained: Physical Inventory Summarized
Use this report to review summarized physical inventory results. It helps you: Validate inventory accuracy Identify variances in quantity and cost Confirm the financial impact of a physical inventory Standard Reports > Physical Inventories The ...Reporting Explained: Cost Reporting- Inventory Detailed Usage by COGS Account
The Usage Cost report shows the cost of inventory usage during a selected period. It includes detailed costs related to: Manual adjustments Invoices (received items) Returns to vendors Issued and accepted transfers Use this report to understand how ...Reporting Explained: Physical Inventory (detailed by Physical)
The Physical Inventory > Detailed (select by physical) report provides a comprehensive view of a Physical Inventory. It shows: All items included in the physical Quantities counted Previous on-hand quantities Variance quantities and variance costs ...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 ...
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 ...