In the Item Ledger Entry for a given item and corresponding location, TOTAL QTY MUST be equal to TOTAL Remaining Quantity, right? Well, for some reason, we ended up with Total Qty <> Total Remaining Quantity...most likely due to incorrect resolution which is adding negative adjustments to an item and its corresponding location in the Item Journal. In any case, now we have a - remaining quantity and Open=TRUE for the item and the given location. when I filter positive=No, remaining quantity= >0, item no=<item> and location=<location>, I get the negative adjustment that we entered to fix the Inventory Valuation problem. In real life, we have NO inventory for that location so we don't want to show any inventory for that item. Hence, the negative adjustments. But it's causing problems in the ITem Ledger Entry, so for future transactions (e.g., receiving purchase orders), we will error out with message "Item not in inventory", because Nav will apply some qty from the qty we are receiving into that negative remaining quantity.
Question: how do we fix Item Ledger Entry so we can get rid of remaining qty=<0 and Open=True? Or moreover, how do we make sure TOtal qty = Total Remaining Quantity?
Any ideas from you would be much appreciated.
*This post is locked for comments
I have the same question (0)
