Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP forum
Unanswered

PO Returns and QTY Available

Posted on by 22,647

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.

Categories:
  • Bill Campbell Profile Picture
    Bill Campbell 22,647 on at
    RE: PO Returns and QTY Available

    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?

  • Tami Farrelly Profile Picture
    Tami Farrelly 5,080 on at
    RE: PO Returns and QTY Available

    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 :)

  • Bill Campbell Profile Picture
    Bill Campbell 22,647 on at
    RE: PO Returns and QTY Available

    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.

  • Tami Farrelly Profile Picture
    Tami Farrelly 5,080 on at
    RE: PO Returns and QTY Available

    So its designed that way...or they just forgot a little piece of code?

  • Bill Campbell Profile Picture
    Bill Campbell 22,647 on at
    RE: PO Returns and QTY Available

    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.

  • Tami Farrelly Profile Picture
    Tami Farrelly 5,080 on at
    RE: PO Returns and QTY Available

    We find reconciling helps with a lot of these "glitches"

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,564 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,651 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Product updates

Dynamics 365 release plans