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 Physical Inventory Summary report provides a high-level view of inventory before and after a physical count.
It includes:
- On-hand quantities before the physical
- Counted quantities and costs
- Updated on-hand values after commitment
- Variances in quantity and cost
You can run the report by:
- Category
- Department
- Store
Generate the report
- Go to Reports > Standard Reports
- Select Physical Inventories
- Select a report version:
- Category
- Department
- Store
- Apply filters (date and store)
-
Click Generate
| Column | Description |
|---|---|
| Previous On Hand | Quantity on hand immediately before the physical (based on effective date/time) |
| Item Counted Quantity | Quantity of inventory items counted |
| Related Counted Quantity | Quantity of related items (child or batch items) counted |
| Total Counted Quantity | Total counted quantity, including items and related counts |
| Counted Cost | Cost of counted items at the time of the physical |
| New On Hand | Updated on-hand quantity after the physical is committed |
| New On Hand Cost | Total cost of inventory after the physical is committed |
| Variance Quantity | Difference between expected and counted quantities |
| Variance Cost | Financial impact of the variance |
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: Inventory Transfers: Summary
Business Need: This report will provide a summary of all transfers for an organization summarized by document How it works: This report will display the issuing and accepting locations, the issued, and accepted quantities, and document status. ...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: Inventory Requests: Summary
Business Need: This report will provide users with an overview of all Inventory Requests that have been created over a period, when they were committed, and can be filtered by document status’ How it works: This report displays the commit date and ...Reporting Explained: Purchase Order Summary
Business Need: This report will provide an overview of all purchase orders for an organization summarized by document. How it Works: Users will filter to a specific date range and have the option to include or exclude certain Status’ as needed. The ...
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 ...