Announcements
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.
*This post is locked for comments
Hello Microsoft - is there anyone there that would like to comment on this matter. I know that this is a community based forum, but really when it comes down to it, you are part of the community.
So, anyone?
I always open support incidents on these types of things...if is a bug they fix it for free or give you a work around :)
If the answer is 'designed that way' we have a problem. If we are missing or have not determined the right process - then the bad is on us.
However, notice the lack of attention tells me something - if someone from Microsoft has some input it would be great to hear about what we are doing wrong.
So its designed that way...or they just forgot a little piece of code?
Tami thanks for that - but we don't think this is a glitch.
We took an item - added the 15 Orders and created all the PO's from the Orders - on purpose.
So we then wanted to see what happens when we tried to return one of the items. It fails no matter what we do.
We find reconciling helps with a lot of these "glitches"
André Arnaud de Cal... 291,359 Super User 2024 Season 2
Martin Dráb 230,370 Most Valuable Professional
nmaenpaa 101,156