Difficulty Level - Intermediate Impact - Store Level

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:

    1. Select Inventory from the Filter drop-down list.

    2. Click on Inventory Count Sheet Audit from the List box in the left pane.

There are two Modes available to audit items:

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

  2. 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:

The following information is displayed for Items not in custom count sheets:

View Inventory Items Not Linked to a Supplier Product

  1. Go to Inventory Count Sheet Audit settings.

  2. Select the Area* and Store from the drop-down list(s).

  3. Select the Sub-Category from the drop-down list if you'd like to filter the results.

  4. Select Items not linked to a Product from the Mode drop-down list.

  • If you no longer use an item at your store:

    1. Remove the checkmark from the Inventoried column of the item.

    2. Click on the Submit button.

  • To use the current inventory of the item until it is depleted:

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

    2. Click on the Submit button.

Click here to learn how to create a new Supplier Product and map it to the inventory item.

View Inventory Items Not on Any Custom Count Sheets

  1. Go to Inventory Count Sheet Audit settings.

  2. Select the Area* and Store from the drop-down list(s).

  3. Select the Sub-Category from the drop-down list if you'd like to filter the results.

  4. Select Items not on custom count sheets from the Mode drop-down list.

To assign the items to existing custom sheets: