Situation:
Client has Item#111 and there are 14 On Hand and 14 Available.
Creates 15 unique Sales Orders that each require 1 of Item 111
Now the QTY O/H = -1 and QTY Available = - 1
Now while getting ready to SHIP these items client determines that one of the items is damaged and it has to be returned to the VENDOR. Simple - just create a RETURN from Purchasing and it is taken care of. Well not so fast. First rules for returns say that the Qty Available for any item is the MAX that you can return - now in our case the QTY Avail = -1
Fix would be to remove the item from one of the Sales Orders. This done - the QTY Available = 0 - not fixed as you can only return a MAX of ZERO
Second Fix - remove from a second Sales Order - this gives me the QTY Available =1 - now I can return. PERFECT (not really)
What do you do to track the two orders that have been destroyed to get the one item returned?
QUESTION
How do you handle this in the real world????
Added COMMENT
This is a simple problem - but the solution we have to work around is not workable at all. In the real world this client will create 40 or 50 work orders that will drive the available QTY to - 40 or 50 of an item - then the system generates the PO and the order is placed and inventory arrives. The S/O are filled - but in this case not invoiced as the work is not done - so they all sit there as S/O documents - QTY Available ZERO - and if one or more have to be returned the current solution as we understand it will not work.
We have tried to remove the POP/SOP link - change the amount on the Sales Order - that works if you need 1 and the QTY Available is ZERO - but what if it is -10 and you need to return just one - then it fails - there is no way that we can / could or should - have to edit all the S/O docs just to allow the system to return a broken item.
Need to resolve this as soon as possible. I need to make this happen - the client and developer have been more than patient and this has been / continues to be an issue in the system and there is no work around that we are aware of. If there is a simple fix we are all into a simple fix.
Thanks.