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
Regular physical inventories help maintain accurate on-hand quantities and ensure reports reflect true inventory valuation. Permissions: View and edit Physical Inventories System Preparation: For the most accurate count, complete the following ...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 ...How do I use Par & Re-Order Points?
What is a Reorder Point? The minimum quantity you would like inventory of the item to be before ordering more. Items must go below this level to trigger reorder. Items set to 0 will not reorder until you go into negative stock. This is not ...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 ...What are Bins and how can I use them?
Bins are supplemental location markers. Unlike flags they do not have to be created prior to assigning them to items and are primarily used in in the stores tab to identify more precisely where an item is located. They can also be used in Physicals ...