When entering inventory counts, quantities are first entered manually for everything that is actually counted. Then, all blank counts are filled in with By Exception. This allows you to enter only what was counted, without needing to enter a quantity for every single product and pack size. The count quantity used for these blank fields will depend on the storage location’s closing method in Enterprise Manager.
However, if there is an on-hand quantity in a storage location that is excluded from the count sheet, then By Exception will always use book quantity, regardless of the storage’s closing method.
Remove an on-hand quantity from an excluded storage
In some cases, an old on-hand quantity can remain in an excluded storage, causing an incorrect inventory count for the product. These steps will remove this incorrect on-hand quantity, so it is not pulled forward from period-to-period.
Determine if book quantity was used By Exception
Use the following steps to see if an on-hand quantity is being pulled forward with By Exception.
Uncheck Summarize by Product from the Inventory Review screen. This will separate the counts by storage location.
Compare the book quantity (how much is on-hand) to the physical quantity (how much was counted). Note any storages where the book and physical quantity are the same.
Confirm this product/storage combo was entered By Exception using the Inventory Audit.
Check if the product/storage combo is excluded from the count sheet on the Inventory Setup screen (Include on Count Sheet = N). If you do need see the product, update the filters on this screen to include all items.
Remove an incorrect on hand quantity from a storage
These steps will remove the incorrect on-hand quantity from the storage location.
Check Include on Count Sheet to add the product/storage combo to the count sheet. If you do need see the product, update the filters on this screen to include all items.
On the next Final for Post inventory, enter a zero count for this product/storage combo.
Review and post the inventory period.
Uncheck Include on Count Sheet to remove the product/storage combo from the count sheet.
Comments
0 comments
Article is closed for comments.