Try Microsoft Edge
A fast and secure browser that's designed for Windows 10
I have a particular item that has 35 units on the item card's Quantity on Hand, but it shows 0 quantity in bin. I created a negative adjustment. However, when I post it to GL it says I don't have the inventory to do it. How can I clear out the Quantity on Hand to 0 so it matches bin content which is 0?
Have you checked Item Ledger Entry? Do you have 35 items on location X (no warehouse location, so Bin is blank)? A negative adjustment with qty 35, location X is right.
Make sure you check in all the locations. Try to filter the Bin Contents table for that particular item and check.
if you use advanced warehouse (directed put-away & pick), you might want to run 'Calculate Warehouse Adjustment' from the Item Journal. In this case whenever the adjustment is made on the warehouse level (Bins), someone has to record it on the Item Ledger Entry level, using Calculate Warehouse Adjustment and posting that journal. Only then Bin Contents will match the Item Ledger Entry.
Hope that helps.
I have done that. Every time that I try to post the journal adjustment, it tells me that I have insufficient inventory to do it. If I delete the entry then re-run Calculate Warehouse Adjustment, the entry repopulates but still won't let me post when I try.
Ok, two quick questions:
- When you run the 'Calculate Warehouse Adjustment', what quantity does it give you? Is it 35?
- Go to Item card and click 'Item By Location'. What does it tell you there on the location in question?
After I run the Calculate Warehouse Adjustment, the quantity shows 45 on the populated entry.
Item card shows 39 in quantity with a Net Invoice Quantity of 5.
It does seem confusing, although I'm sure there is a logical explanation, just difficult to see without deeper analysis of transactions. I can't think of any plausible scenario where remaining ILE quantity (39) is less than the required adjustment (45). Not sure what Net Invoice Quantity is - that must be a bespoke development.