Troubleshooting: How do I start investigating variances in my physical?

Troubleshooting: How do I start investigating variances in my physical?

The first place to start investigating variances in your physical is an Item History report. This report will provide detailed information regarding when your item was purchased, received, manually adjusted, sold & inventoried. Variances are most often a result of a miscount on an item, missing sales or purchasing. 

Where can I find an item history report?

This report is in numerous places around the software including but not limited to: 

  • Inventory Items Screen (Yellow Dog home page)
  • Stores tab of the item editor
  • Physical Inventory editor
  • Everything purchasing document editor
  • Standard Reports 

If while you are generating an item history report any data is filtered the report will only pull data for the corresponding filters. i.e. if you are generating an item history report from within a purchase order the report will only pull item data for the corresponding store the PO has been created for. Similarly, if you are generating an item history report from the inventory items screen and you have filtered to only display one store the report will only pull data for the corresponding store. 

Generating an Item History Report:

Anywhere you see the button Item History Report for….: 



Select what to show: 

If the item is apart of a parent/child relationship, there is will be second check box with option to include related items.  


  • By selecting the Only show on hand adjustments box only activities that have impacted the items on hand will be returned. So, if the item had a 0 variance on a physical (meaning the qty counted matched what was already in Yellow Dog) that physical will not appear if this filter is selected. 
  • Leaving the box unchecked will not only provide examples of actions performed by end users that did not update that adjust on hands but will also show background processes that have impacted the item. i.e. if you have updated the store availability of an item or triggered it to be re-synced to your point of sale

 

Anatomy of an item history report: 

The top and bottom of the report will the same as all other reports found in Yellow Dog: You will see the filters selected at the top and you will find options to print, save and export at the bottom. You will also find several other standard columns: Store, SKU, Level, Date/Time, Vendor etc. 



  1. Adjusted: This column indicates how much of your item was adjusted based on the corresponding action that was performed. i.e. If you had a variance of -5 on a physical, then the adjusted column would say -5 indicating that 5 had been removed from your on hand.
  2. Item Calculated Cost: This will be the calculated cost of the item at the time of the action. 
  3. Extended Calculated Cost: This is the calculated cost of the item x the adjusted qty. i.e. If your item has a variance of -5 in your physical with a calculated cost of $15 the extended calculated cost for the for that item’s adjustment would be $75. 
  4. Store on Hand: This will be the on hand for that item and location. 
  5. Employee: This will be the Yellow Dog user that was logged in at the time the action took place
  6. Document: This will provide the document number for the that action.  This column is not defaulted on, but can added by using the Change Columns, Sorting, Grouping hyperlink. 
  7. Action: This will be the name of what happened to the item. i.e. Manual Adjustment, POS Sale/Return, Physical Inventory, etc. 
  8. Reference: If the action performed has a reference field with data in it, that data will populate here. i.e. if you have notes in the reference field of a purchasing document those notes will populate this column. 



    • Related Articles

    • COGS Troubleshooting

      This document was designed to help users pinpoint where and why there are discrepancies in their COGS reporting.  Why COGS are inaccurate: If COGS numbers are appearing incorrectly in Yellow Dog one of the following will be the cause: Invoices were ...
    • What are Yellow Dog's Best Practices for Physical Inventories for F&B Customers?

                                                   Best Practices   F&B Physical Inventory Best Practices                                                                                                                                                      ...
    • Reporting Explained: Troubleshooting- Received Items Not on Any Physical

      Business Need: This report is helpful for users after doing their monthly physicals. It allows users to see any items received into inventory that are not included on a current physical.  For more information on physical inventories click here.  How ...
    • 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 ...
    • Reporting Explained: Physical Inventory (detailed by Physical)

      Business Need:  This report is helpful for users who are looking for a detailed report on a physical inventory.  This report will detail data on items included in a physical and show variances and variance costs for items on that physical. How it ...
    • Recent Articles

    • Send Saved Report Emailing

      You can configure saved reports to be automatically emailed to you and/or team members on a set schedule. How do I schedule daily email reporting? You can configure saved reports to be automatically emailed to you and/or team members on a set ...
    • Purchasing Flow for Food and Beverage

      The Yellow Dog Inventory purchasing flow ensures that all aspects of inventory management, from restocking to adjusting errors in transfers, are covered systematically. Each document type in the flow serves specific functions that collectively ...
    • Updating Count XL Application

      You may need to update your Count XL application on your handheld device to ensure it runs properly and smoothly. If you have received the following errors, your Count XL application may need to be updated: • “Invalid network error” • “API error” • ...
    • Removing Items with On-Hand Quantity (Decimal)

      You might encounter difficulty removing specific inventory items due to an error indicating that the item cannot be removed since its on-hand quantity is not zero, possibly because the decimal point is not properly adjusted. Changing the Decimal ...
    • ZD411 Printer Troubleshooting

      Labels Skipping When Printing When you are not able to print labels or labels are skipped when printing you will need to adjust the sensor inside the printer. If your labels are skipping when printing, make sure you have adjusted your sensor. To do ...