RE: Allocated Inventory when zero quantity on hand
Hi Katy,
Like Frank, I'm a bit confused as to the problem. I have a little time here, so let me go through what I think might be the problem. It may not be, but this is my interpretation:
1. They created an inventory adjustment that increased the quantity on hand of XYZ item from zero to let's say 10.
2. They sold a quantity of 10 of the XYZ item on a SOP document.
3. The quantity sold was allocated and fulfilled thereby reducing the quantity available for sale to zero.
4. On the inventory inquiry window the Quantity on Hand is 10, the quantity allocated is also 10. The quantity available is zero.
5. They realized the adjustment that increased the quantity of the XYZ item to 10 was wrong.
6. They reversed the original adjustment thereby reducing the quantity on Hand to zero.
7. Since they had previously sold 10 XYZ items, the quantity allocated is still 10 and the quantity available is now showing -10
If the above is correct, the system is working as designed. The only way that I know of to 'un-allocate' the quantity is to take it off of the SOP document. None of the utilities will change those quantities.
If they are trying to create a PO from the SOP document, they will not be able to because the SOP document will show the entire quantity as fulfilled. In order to create the PO, they need to change the Qty to Invoice and the Qty Fulfilled to zero. Then change the Qty to Back Order to however many you want to order.
Does the above describe your situation?
Kind regards.
Leslie