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
Related counts from recipes and related sizes
This report is useful for reconciling inventory accuracy and identifying discrepancies.
You can access this report in two locations:
-
Reports > Standard Reports > Physical Inventory
-
Within a committed Physical Inventory
The report compares the previous on-hand quantity in Yellow Dog to the counted quantity recorded in the selected Physical Inventory. It calculates:
-
Variance quantities (differences between expected and counted values)
-
Variance costs
-
Additional counts from related sizes and batch recipes
Required Filters
-
Go to Reports > Standard Reports.
-
Open the Physical Inventory folder.
-
Select Detailed (select by physical inventory).
-
Choose the Physical Inventory to include in the report.
Apply any additional filters as needed.
-
You may select multiple Physical Inventories.
-
Optional Filters
- Hide committed
- Show only items with no counts entered
- Show only uncommitted
| Column | Description |
|---|---|
| Physical Inventory Number | The physical inventory (PI) number associated with the row. |
| Status | Indicates whether the physical inventory is committed or uncommitted when the report runs. |
| Description | The name of the physical inventory. |
| Effective Date/Time | The date and time assigned to the physical inventory. This determines when on-hand quantities are updated. |
| Unique SKUs | The number of distinct items included in the physical inventory. |
| Previous On Hand | The item’s on-hand quantity immediately before the physical inventory was committed. |
| Item Counted Quantity | The quantity counted directly on the physical inventory. |
| Related Counted Quantity | Counts applied through related sizes or batch recipes. |
| Total Counted Quantity | The total quantity used for adjustment, including related counts. |
| Variance Quantity | The difference between the previous on-hand quantity and the total counted quantity. |
| Variance Cost | The cost impact of the variance for the item. |
| On-Hand Cost | On-Hand Quantity × Average Item Cost. This value reflects the calculated cost, not vendor pricing. |
| Counted Cost | Previous Calculated Item Cost × Counted Quantity. The counted cost here is based on calculated cost, not the vendor price. |
Related Articles
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: Cost Reporting- COGS Detail
The COGS Reporting report helps food and beverage (F&B) customers track inventory costs. It provides a detailed breakdown of Cost of Goods Sold (COGS) accounts and shows how costs relate to: Sales Purchases Physical inventories Manual adjustments Use ...Reporting Explained: Food Cost by COGS Department/Category
The Food Cost by COGS Department report shows food cost summarized by COGS department. Use this report to compare inventory costs with sales revenue and monitor food cost performance by department. Reports > Standard Reports > F&B > Food Cost > COGS ...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 ...
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 ...