Does anyone know what the difference is on an item...
# general
m
Does anyone know what the difference is on an item record’s inventory tabs “Inventory Detail” and “Inventory Numbers”? There is a lot number that shows up on Inventory Numbers but not Inventory Detail and I wondered why since it should be available.
k
Most likely explanation is someone did something they shouldn't have.
Backdating transactions, deleting transactions, doing a bin putaway worksheet after doing an item receipt, deleting a bin transfer, all kinds of hijinks
Best bet is to customize your view on that page and make it "not equal to 0" instead of greater than for the quantity on hand field.
That'll expose where you have problems so you can figure out the involved transactions and fix them.
m
Thanks for this. I altered the view as you said and it did come up. It seems to show the original bin number from the other manufacturing subsidiary in inventory detail, but the inventory numbers tab shows the right quantity and location. What is the inventory detail supposed to be for on the item record?
k
In theory they should match - depending on what caused them to go out of whack, your fix will vary.
Unfortunately, it can be hard to diagnose over chat. I'd suggest contacting NS support.
m
Thanks. I think I got it. The Inventory detail tab is based on a bin number search. The item was received into a location without a bin. That’s why it’s not showing I believe.
k
Maybe. Could be a bunch of causes.