Reporting Explained: Troubleshooting- Received Items Not on Any Physical

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 it works: This report is based on a single start date to present date and can be generated for a single store or multiple. It will populate all items that have been received into your inventory through receipts or invoices that have not been counted on a physical inventory within the date range. To generate this report, you will need to maintain your inventory by using either receipts or invoices. For more information on purchasing click here. The “Start Date” is the beginning of the date range. When using this report to check for missed items on a current Physicals choose a date range that starts after your previous physical. 

Generating the Report: 


Go to the Reports section in Yellow Dog 

  1. Select Standard Reports
  2. Open the folder titled Troubleshooting
  3. Select “Received Items Not On Any Physical” 
  4. Select Start Date
  5. Select Store
  6. Generate Report
  7. ​

Reading the Report 


  1. Shows the filters used to produce the report’s data, including the date selected for the report.
  2. Change columns, sorting, and grouping: This allows us to manipulate the view of the data within the report. Other columns available in this report are used to organize and sort items. Please see report more information.
  3. Receipts: Number of Invoices or receipts the items has been received on based on store.
  4. Received: Quantity received between date range based on receipts column
  5. Problem: Explains the reason the item is on the list
  6. Level: Levels the item is assigned to.
  7. Vendor: Vendor assigned to item
  8. Sku: Item Sku number 
  9. Item:  Item description
  10. Store Code: Code of store item was received in
  11. Store Name: Name of store item was received in
  12. Current On Hand:  On hand in the corresponding store
  13. Last Transaction: Most recent sale of item in corresponding store 
  14. Last Adjustment: Most recent on hand adjustment 
  15. This row allows you to save, export, print and close the current report.






    • Related Articles

    • Reporting Explained: ReOrder

      Reporting Explained: Re-Order Business Need: This report will show items that are either at or below the re-order point assigned, and include the quantities needed to bring the items back up to Par. How it works: To best utilize this report users ...

    • Reporting Explained: Troubleshooting- Received Items Not on Any Count Sheet

      Business Need: This report is helpful for customers who use Count Sheets. It allows users to see any items received into inventory that are not included on any count sheet. Click Here for more information on count sheets. How it works: This report is ...

    • Reporting Explained: Troubleshooting- Items Locked

      Business Need: This report is helpful for customers who need to manage items that are locked due to being on a purchasing document. It also helps in locating the purchase order number for any item with an on-order quantity. How it works: When an item ...

    • 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 ...