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

Note: This version displays results by item. Other formats are available, including by dimension, level, store, and 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 

1. Go to Reports > Standard Reports.
   
2. Select Inventory > On Hand > By Item.
   
3. Set the Date/Time filter. By default, it is set to Now, but you can choose any date and time.
   
4. Apply additional filters as needed.
   
5. Click Generate.
   

Additional Filters:

You can filter the report by:

1. Stores
2. Levels
3. Vendors
4. Evergreen
5. Dimensions
6. Combine Stores
7. Include or exclude inactive items
8. Only show inactive items
9. Only show items with negative on-hand
10. 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: 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 ...

• Reporting Explained Physical Inventory Summarized by Store

  Business Need: This report is helpful for users who want to view Physical Inventory data summarized to a single line per location. How it Works: The Physical inventory report Summary by Store will provide information on the Stores total on hand going ...

• 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 ...

• 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 ...