Scenario
When the Inventory Count transaction status is set to Started, a snapshot of the inventory on hand quantity is taken from the system for comparison. The error happens if a user continues to process inventory changes while the counting activities are occurring so please note these changes. Please include these changes when a user enters the Count Quantity into the inventory count transaction.
Solution
Compare the Snapshot on the Inventory page with the current Bin On Hand, user may create a Saved Search. Below are the steps:
1. Navigate to Lists > Search > Saved Searches> New.
2. Choose Transaction.
3. On the Criteria tab > Standard subtab, add the following filters:
a. Type = Inventory Count
b. Quantity = equal to ‘select the number of the Inventory Count’
c. Main Line = False.
4. On the Results tab > Columns subtab, add the following fields and corresponding Summary Type:
a. Field: Date | Summary Type = Group
b. Field: Item | Summary Type = Group
c. Field: Formula (Text) | Summary Type = Maximum | Formula = Case when {transactionlinetype} = ‘Snapshot Quantity’ then {quantity} Else null END| Summary Label = Snapshot Quantity
d. Field: Transaction Bin Number | Summary Type = Group
e. Field: Item Fields… Bin Number | Summary Type = Group
f. Field: Item Fields… Bin On Hand Count | Summary Type = Maximum.
5. On the Available Filters tab, add the following and mark the Show in Filter Region check box for each line:
a. Filter: Item Fields… Inventory Location
b. Filter: Bin Number Fields… Location.
6. Rename the Search Title.
7. Click Save & Run. On the Results page, make sure to set Inventory Location and Location filters to Location set on the Inventory Count.
NOTE: Error will occur, if any item is in picked/packed state, also if any transaction happens while inventory count.