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 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 added to a count sheet within the date range. To generate this report, you will need to maintain inventory by using either receipts or invoices. Click Here for more information on Purchasing. The “Start Date” is the beginning of the date range.
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 Count Sheet”
- 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 is received in
- Store Name: Name of store item is 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, or close the current report
Related Articles
Reporting Explained: Troubleshooting- All Items not on any Count Sheet
Business Need: This report is helpful for managing count sheets. If managing items through count sheets this report lets users know which items have not been included on a count sheet. How it works: This report checks against all count sheets within ...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 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: 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 ...How do I create a Count Sheet?
This video will demonstrate creating a Count Sheet Count Sheets were designed to help F&B users who are manually counting their inventory. These sheets can be made to mirror the lay out of your establishment, and we refer to this as ...