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
- Select Standard Reports
- Open the folder titled Troubleshooting
- Select “Received Items Not On Any Physical”
- Select Start Date
- Select Store
- Generate Report
-
Reading the Report
- Shows the filters used to produce the report’s data, including the date selected for the report.
- 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.
- Receipts: Number of Invoices or receipts the items has been received on based on store.
- Received: Quantity received between date range based on receipts column
- Problem: Explains the reason the item is on the list
- Level: Levels the item is assigned to.
- Vendor: Vendor assigned to item
- Sku: Item Sku number
- Item: Item description
- Store Code: Code of store item was received in
- Store Name: Name of store item was received in
- Current On Hand: On hand in the corresponding store
- Last Transaction: Most recent sale of item in corresponding store
- Last Adjustment: Most recent on hand adjustment
- 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 ...