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
Hmm.. this may not be a best solution but just an idea, try to disable the In-Transit for that location using a processing report without executing validation, then run your movement worksheet and enable the In-Transit.
We tried that. but the source location is a transit location so Movement worksheet doesn't seem to work. :(
May be create a temporary location and move the inventory to that location.
of course not. We know what caused the item to get stuck in a transit location. moving forward it won't happen again. However, perhaps our resolution didn't work as it caused the total qty <> remaining amount. right now, our goal is to just make sure total qty = remaining qty. currently, physically, there are NO qty in this transit location.
...and you plan on adjusting individual SKU's daily forever going forward?
I'd like to know what the root cause is and fix that.
HI Suresh. Unfortunately, when I applied a neg adj and applied to the entry with neg remaining qty, that just zeroed out the remaining qty. But if I total the quantity and compare with total remaining qty, total qty is > remaining qty still. So this means, it will cause problems for future purchase orders...receiving them. How do you somehow transfer a qty from a warehouse (without bins....this is not a real warehouse...just transit) to another? I need to make sure Total Qty = Total Remaining Qty for a given item, location.
Please check the applied entries for that item ledger entry and i am pretty sure there will be no entries, if you make a +ve adjustment of that quantity for that location then it will apply each other and remaining quantity will be zero,
Although i don't know what is the cause but i have seen those cases earlier.
André Arnaud de Cal...
291,996
Super User 2025 Season 1
Martin Dráb
230,853
Most Valuable Professional
nmaenpaa
101,156