RE: Ghost inventory in bins
I saw a question similar to this, but it didn’t really provide an answer that was helpful in my situation. We have several items that show quantity available in the bin under inventory detail, but there are zero quantities on hand (as proven by physical count). I am not clear as to why this happens, I suspect it is related to questionable adjustments or transfers? If I do an inventory adjustment, it will then show negative quantities on hand. How can I simply remove the inventory in these bins to clean it up?
There are a number of methods established for doing this.
I believe the NetSuite PS approach involves turning bins on and off. I’m not 100% sure if there are additional steps to take.
The most common offenders for this is doing an item receipt, vendor bill (if not associated to a PO), or inventory adjustment without a bin, performing a bin put away worksheet, and then going back and putting the bin on the receiving transaction.
My preferred method is to track down what happened so I can whack people on the wrist so they don’t do it again and fix it on the transactions (most commonly removing the duplicated item on the bin putaway worksheet)
My viewpoint is – you either do bin put away worksheets or you don’t. If you do bin putaway worksheets, don’t edit item receipts. If you don’t do them, then edit them.
This could also happen if someone reduces inventory before another transaction occurs move inventory away. Generally this is solved by forcing people to not backdate things. I don’t care *when* it actually happened, I just care that my current inventory doesn’t match. Fix it now, not in the past. Changing stuff in the past often has very unintended consequences.
Another common issue is if items were put into one bin, and then someone edits a transaction that pre-dates it to change quantities.
The method I most commonly use for finding this is to search for bin on hand or inventory detail (depending on if you are using lot numbers) where the quantity is *not* equal to zero as opposed to greater than zero. This would accommodate for “oh i pushed inventory around.