The Inventory Count Sheet Audit page helps you identify and resolve inventory items that don't have a supplier product mapped to them and inventory items that haven't been added to any custom sheet. Adding inventory items to custom count sheets immediately updates the selected sheets, including any that are currently open, allowing the newly added items to be included in ongoing counts.
To access Inventory Count Sheet Audit settings:
Select Inventory from the Filter drop-down list.
Click on Inventory Count Sheet Audit from the List box in the left pane.
There are two Modes available to audit items:
Items not linked to a product identifies inventory items that do not have a supplier product mapped to them and hence cannot apply a cost of usage. Inventory items are included in this list for one of two reasons:
Inventory items that have been invoiced before and are no longer mapped to a supplier product for one of various reasons (for example, the supplier no longer carries the item and you've not found a new supplier for the item as yet, or you no longer work with that supplier and have not found a new one yet, etc.).
Inventory items that are included in your store's Inventory Item by Location but have never been invoiced (the invoiced supplier product could be linked to a different inventory item).
The Use Last Purchased option is not available for inventory items that have never been invoiced.
Items not on custom count sheets identifies active inventory items that are not assigned to any Custom count sheet and allows you to add them to existing Custom count sheets.
The following information is displayed for Items not linked to a product:
Inventory Item: The inventory item that's not linked to a supplier product.
Sub-Category: The sub-category in which the inventory item is classified.
Supplier Product: Confirmation that a supplier product is not mapped to the inventory item.
If the option to Use Last Purchased is not available for an inventory item, you will not be able to create a physical count until the inventory item is removed from inventory.
Click here to learn how to remove an inventory item from a store's inventory.
Use Last Purchased: A checkmark in this column indicates that you're presently using the inventory you have in stock.
The following information is displayed for Items not in custom count sheets:
Inventory Item: The inventory item that's not on any custom count sheet.
Sub-Category: The sub-category in which the inventory item is classified.
Custom Count Sheet: Links out to the Choose Custom Count Sheet window that allows you to add unassigned inventory items to one or more custom count sheets.
Go to Inventory Count Sheet Audit settings.
Select the Area* and Store from the drop-down list(s).
Select the Sub-Category from the drop-down list if you'd like to filter the results.
Select Items not linked to a Product from the Mode drop-down list.
Remove the checkmark from the Inventoried column of the item.
Click on the Submit button.
Place a checkmark in the Use Last Purchased column of the item.
The Use Last Purchased checkbox will not show if there isn't a supplier product mapped to the inventory item, or if an inventory items is included in your store's Inventory Item by Location but has never been invoiced.
Click on the Submit button.
Click here to learn how to create a new Supplier Product and map it to the inventory item.
Go to Inventory Count Sheet Audit settings.
Select the Area* and Store from the drop-down list(s).
Select the Sub-Category from the drop-down list if you'd like to filter the results.
Select Items not on custom count sheets from the Mode drop-down list.