on Inventory Adjustment record, When I type in the item number I see 94, but when I click on the inventory detail I see 101, does anyone know how would I adjust out the 7 that's sitting in nowhere land, It is not on the bin putaway worksheet, on the item record it shows in a particular bin.

edit the view on the page you see the different number and change the criteria from "greater than 0" to "not equal to zero" - that will show you where your negative inventory is - and then you can do a inventory adjustment to modify the negative to zero, and your positive to what's actually there

hmm on the item record it shows 101, but not sure where the 101 is. I see the bin number, but again, Available is 94.

Does your "On Hand" also show 94? You may have 7 committed, so only 94 available + 7 committed = 101 On Hand. Alternatively, if you are using RF Smart, some quantities may be hiding in a setup or picked bin.

it's something funky going on here.

Can I see what it shows if you click on the "Bin Numbers" tab of that screenshot? Also, show me where the 101 number is coming from.

Customize your inventory detail view and change the on hand to "not equal to zero" instead of greater than zero. You have to have negative inventory.

I did that but i am only seeing this two lot numbers and the bin numbers

Did someone do a bin putaway worksheet and then go back and edit the item receipt to have a bin?

i see the negative number

Tadaa - now you move inventory around using inventory adjustments, and the right bins and the right quantities to set your negative to zero - and adjust down your positive values.

that negative quantity doesn't have the bin though

Try looking for bin putaway worksheets that hit that serial number then

It is the same serial number as the other bin, so looks like someone deleted the bin putaway maybe?

Not if it makes the no bin value negative.

ooo you might be onto something let me check that

Revisionist history on inventory is a dangerous game. Sometimes it makes life easier - other times it creates dead/bad records.

oo this going to be fun, this is asssembly item not something we buy

maybe it was a deleted bin transfer tranasction?

Yea i do see three Bin transfer that were deleted but unfortunately that won't tell me which items were on that bin transfer