Bin quantity is out of sync with Location quantity
We use RF-Smart WMS. For various process reasons (such as deleting Inventory Transfers that were entered incorrectly in the first place) we have a number of items that are showing a quantity under the Inventory Detail tab in a bin but in the Purchasing/Inventory/Location is a lesser quantity (the location tends to actually be the correct quantity). Is there a way to sync or correct the bin quantity so that it matches the Location quantity?
Hi mike,
the reason why the inventory bin quantity and inventory number is not tally is because of floating qty on hand that no assigned on bins.
You can use the bin put away worksheet under transaction to generate all unassigned item to bin.
then, do an audit or physical count to check the accuracy of that floating qty on hand.
Once you have the actual bin assignment, you can update the inventory detail to assign the exact bin based on physical location.
Hope this will help. Thank you!
JRC
The best bet here is to do a search for inventory detail where quantity is *not equal* to zero instead of greater than 0.
Your most likely offenders are that you have negative inventory on hand but you just don’t see it when looking at the item.
Once you’ve identified offenders, then you can do an inventory adjustment in to the bin that is negative on hand, and then an inventory adjustment out of the bin that shows as on hand incorrectly.
Watch your costs as you do this exercise – it’s easy to bring it out at a dollar value, and in at 0.
Regards.
mikerad
Hi JRC,
Thanks but there is nothing in the Bin Putaway Worksheet. The bins being out of sync with the locations is I believe as a result of process, i.e. deleting transactions or transfers. Deleting these rectifies the inventory in the location but it does not reconcile the movements to and from bins. The bin quantities remains intact, hence the discrepancy between Location and Bin
Mike
John R. C.
Hi Mike,
I think that too hard to reconcile. my suggestion is have physical count.
Then apply to inventory. hope this will work!