web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

GP 10 Sales Order QTY ordered does not equal QTY on PO

(0) ShareShare
ReportReport
Posted on by 75,848 Moderator

We generate all of our PO's off sales orders. I had one of my users come in and show me a sales order where the quantity ordered was 3 but when you look at the PO generated from this sales order the quantity on the PO is only 1. Now I just ran a quick query against the SOP10200 and the SOP60100 table comparing the SOP10200.QUANTITY field to the SOP6100.QTYONPO field and much to amazement there are almost 600 other lines just like this where the quantities are different. They process about 10,000 orders per month with 100's of lines per order. This is not an acceptable failure rate.

Has any one else seen this type of behavior? Under what circumstances would this occur?

*This post is locked for comments

I have the same question (0)
  • DinB Profile Picture
    3,951 on at

    It may happen in following case:

    User entered 3 Qty in Sales Order, GP had 2 available and it automatically fulfilled 2 and put 1 as back order. When the PO was generated, it generated PO only for the 1 that was back ordered in Sales Order.

  • Richard Wheeler Profile Picture
    75,848 Moderator on at

    The item this happened on today was a service item so that should not have been the case.  I will take a copy of the database and move it onto a test image to see if I can get it to do it under various conditions. On the SOP10200 record for this line today the backordered quantity was zero. I am very concerned about those 583 records I see in the SOP10200 table that have this condition. They must be doing something to cause this to occur. Today is the 115th day of the year so this is happening about 5 times a day.

  • Richard Wheeler Profile Picture
    75,848 Moderator on at

    Here is a screenshot of an example. I have tried purposely to cause this and I cannot. Notice how the qty on the sales line is 6 but on the PO line it is only 1. This item is a service item so no back ordering involved here.

  • GPDavid Profile Picture
    2,250 on at

    Are varying Units of Measure coming into play here?  For example, is the PO ordering in one unit of measure while the Sales Order is selling in another?

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans