Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / GP 10 Sales Order QTY ...
Microsoft Dynamics GP (Archived)

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

(0) ShareShare
ReportReport
Posted on by Richard Wheeler 75,730

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

  • GPDavid Profile Picture
    GPDavid 2,250 on at
    Re: GP 10 Sales Order QTY ordered does not equal QTY on PO

    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?

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    Re: GP 10 Sales Order QTY ordered does not equal QTY on PO

    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.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    Re: GP 10 Sales Order QTY ordered does not equal QTY on PO

    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.

  • DinB Profile Picture
    DinB 3,812 on at
    Re: GP 10 Sales Order QTY ordered does not equal QTY on PO

    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.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans