Troubleshooting: Variances in a Physical Inventory
Most variances occur because of:
-
Missing or committed receiving/invoicing
-
Missing or unprocessed sales
The Item History Report is the most reliable tool for determining where an item’s on-hand value comes from and identifying the source of discrepancies.
You can access the Item History Report from multiple areas in Yellow Dog:
Inventory Items screen (Yellow Dog home page)
-
Stores tab of the Item Editor
-
Physical Inventory Editor
-
Any purchasing document
-
Standard Reports
If any filters are applied when you generate the report, the results are limited to the filtered scope. For example:
Generating a report from a purchase order shows only data for the store associated with that PO.
-
Generating a report from the Inventory Items screen with a single store selected returns data only for that store.
Anywhere you see the Item History Report for… button, you can generate the report.
Depending on the item and context, you may see the following options:
-
Include related items
Appears when the item has multiple sizes. Select this to include history for related items. Only show on-hand adjustments
Returns only actions that changed on-hand quantity.-
If an item had a zero variance in a Physical Inventory (meaning counted = expected), that Physical will not appear when this filter is selected.
-
Leave this unchecked to include all activity, including background processes such as store availability updates and POS re-sync actions. This option is typically only selected by the Yellow Dog support team
-
The report layout follows the standard Yellow Dog report format:
-
Filters appear at the top.
-
Options to print, save, and export appear at the bottom.
-
Columns such as Store, SKU, Level, Date/Time, and Vendor appear by default.
| Column | Description |
|---|---|
| Adjusted | Quantity added or removed based on the action. Example: A Physical variance of –5 shows –5 in this column. |
| Item Calculated Cost | The item’s calculated cost at the time of the action. |
| Extended Calculated Cost | Calculated cost × adjusted quantity. Example: –5 variance × $15 cost = –$75. |
| Store on Hand | The on-hand quantity for the item at that location after the action. |
| Employee | The Yellow Dog user logged in when the action occurred. |
| Document | Document number associated with the action (optional column; add it via Change Columns, Sorting, Grouping). |
| Action | The type of action (Manual Adjustment, POS Sale/Return, Physical Inventory, etc.). |
| Reference | Notes or reference data associated with the action (for example, notes from a purchasing document). |
Contact Yellow Dog Support if:
-
Sales are missing: Support may be able to pull in missing sales or advise whether manual sales need to be created.
-
Variances remain unclear: If the Item History Report does not clarify the discrepancy, the Helpdesk can assist in determining the next steps.
-
- Phone: 757-663-7514
- Email: support@yellowdogsoftware.com
- Chat: Click here to Chat with a YD Support Guide
Related Articles
How To: Create a Full Physical Inventory
End user · Yellow Dog Inventory 2026 WHY IT'S IMPORTANT Regular physical inventories help maintain accurate on-hand quantities and ensure reports reflect true inventory valuation. PREREQUISITES Permissions • View and edit Physical Inventories System ...Physical Inventory Process for Venue Warehouses
Physical Inventory Checklist One Day Before Physical Inventory ☐ Step 1: Complete all Pre-Inventory Preparations Day of Physical Inventory ☐ Step 2: Count Warehouse Using Handheld with Count XL (Step 2A if alternatively using Count Sheets) ☐ Step 3: ...Troubleshooting: Locked Physical (Unable to Open Physical)
Physical Inventory is locked. If a Physical Inventory is opened and then unexpectedly closed—such as from a computer crash, force closing with the task manager or power outage—the inventory will be locked. Once locked, it can only be accessed by the ...End of Month Process Checklist - FnB (Physical Inventory)
Getting Ready for End-of-Month Physical Inventory? Ensure a smooth, accurate, and efficient inventory count by following our End of Month Process Checklist. It’s your go-to guide for staying organized and on track.FAQs: Why Can’t I uncommit my Physical?
Question: Why Can't I uncommit my Physical Inventory? Answer: You can uncommit a physical inventory only within the 7-day grace period that starts on the date the inventory was committed. The Effective Date does not affect this timeframe. After 7 ...
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: ...How To: Install the Zebra ZD411 Printer Driver
End user · Yellow Dog Inventory 2026 WHY IT'S IMPORTANT When you install the correct driver, Windows can communicate with your Zebra ZD411 printer so it prints labels and tags reliably from Yellow Dog Inventory. Without the driver, the ZD411 will not ...FAQs: What are Bins?
End user · Yellow Dog Inventory 2026 Question: What are Bins? Answer: Bins are optional location identifiers that specify exactly where an item is stored. The Bin field is free text, so you can use letters or numbers. You don’t need to create bins in ...Food and Beverage User Manual
The Food & Beverage User Manual is your key to understanding the potential of Yellow Dog. Whether you're a first-time user or a seasoned pro, this detailed manual will help you understand how to best utilize your Yellow Dog Inventory system. Download ...