Scenario
User wants to identify all the bin location mismatches existing in an environment.
Solution
Usually in these type of mismatches the usual search being used is the Inventory Balance Search. Please see below testing:
My sample Bin Item has 75 on location on hand:
But my sample Bin Item has 85 in under Inventory Detail subtab:
I ran the Inventory Balance Search with below Criteria and Results tab:
And here's the result:
Here you will see that there was a negative movement in my sample Bin Item but the transaction had no Bin. This means that the Bin details is not populated in the transaction record.
I looked at the related records and I saw that there was a negative inventory adjustment that had no inventory detail. Putting the Bin details in the record would resolve the mismatch.
This process can be tedious and not practical especially on fast moving items. Mismatches also happen due to number of reasons too like:
a. Quantity in the Bin Putaway Worksheet has not been putaway yet.
b. There are transactions have not been assigned a specific Bin.
c. There are Bin Numbers that have Quantity On Hand that have been manually removed from the Item Record.
If you have no time to look for the cause and just want a quick fix on resolving the mismatch you can visit SuiteAnswers ID: 62364
-----
If you find this information useful, let us know by reacting or commenting on this post!