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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Create new SOP order, ...
Microsoft Dynamics GP (Archived)

Create new SOP order, sometimes causes two users to get same SOP number

(0) ShareShare
ReportReport
Posted on by Tim Wappat 5,711

SOP entry, user creates a new order to find that it populates with lines from an order that another user is currently entering somewhere else in the room.

Effectively they have both been issued the same new SOP number, I guess. Occurring more frequently since going to GP2010 but did happen before on 9 too. Anyone else seen this solved it or mitigated the risk of people overwriting each other's orders?

*This post is locked for comments

I have the same question (0)
  • Tim Wappat Profile Picture
    Tim Wappat 5,711 on at

    I should add that this form is modified and is running a Visual Studio Addin code.

    Could it be that I am upsetting something inadvertently? The code is doing things like checking for previous customer PO numbers (yes I know these days this is in the prof tool kit) and defaulting the batch field and a bit of other stuff. Like preventing save until all is well with the order.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,850 Moderator on at

    Is this a reproducible event? I would first try removing the VS dll out of the add-ons folder and see if this problem goes away.

  • Tim Wappat Profile Picture
    Tim Wappat 5,711 on at

    Not reproducible on demand, this happens once every couple of days (perhaps) with about thirty SOP users. I'm currently getting users to log when it happens so I can get a genuine quantitative handle on it without user exaggeration.

    Removing the modifications is not really going to work for me as they contain a lot of business workflow logic, essential validation that if removed would present more risk than this problem.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,850 Moderator on at

    Do people start a new SOP document and then back away without doing anything? I am wondering if the SOP number goes back into the pool to be used again.

  • Tim Wappat Profile Picture
    Tim Wappat 5,711 on at

    what do you mean by "back away", they may leave the new SOP number sitting for a while before the next call comes in before then entering the debtor id or may "x" out the window having been on a new SOP number... or do you mean some other scenario I need to be aware of?

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,850 Moderator on at

    Let's say you have 30 people entering orders.

    User 27 is sitting on the SOP screen and has tabbed down to the order number and gets SOP # 0100011 and then just sits there.

    In the mean time, other users are taking orders and now the next SOP # is 01000030.

    Now user 27 exits the screen and never enters anything for order 0100011 so now this order number can be reused. I am not sure if the next user will get 0100011 or will he/she get 0100030.

    Can anyone else chime in on this?

  • Tim Wappat Profile Picture
    Tim Wappat 5,711 on at

    Certainly if the number is released back an no further numbers have been issued, then that previous number will be reissued.

    This is why I feel the client may be incorrectly releasing the number then at a later time saving its tables back to the DB overwriting the poor soul who got issued the number again.

    What triggers are there in the SOP Entry Form for the release of the SOP Number back into the "pool"?

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,850 Moderator on at

    Check out this script to see if Master Numbers are shared by more than one sales document. Perhaps there will be a clue with this.

    -- Script to identify duplicate Master Numbers

    --  on Dynamics GP SOP Documents

    With WorkHistUnion (MSTRNUMB, SOPNUMBE )as

    (SELECT MSTRNUMB,SOPNUMBE  FROM SOP10100 WHERE SOPTYPE=2

    UNION ALL

    SELECT MSTRNUMB,SOPNUMBE FROM SOP30200 WHERE SOPTYPE=2)

    SELECT  MSTRNUMB, COUNT(MSTRNUMB)from WorkHistUnionGROUP

    BY MSTRNUMBHAVING COUNT(MSTRNUMB)>1ORDER BY MSTRNUM

    I found this at

    timwappat.info/.../Duplicate-SOP-Master-number-in-Dynamics-GP.aspx

    There is other useful informnation on this site regarding GP SOP.

  • Tim Wappat Profile Picture
    Tim Wappat 5,711 on at

    Thanks for checking out my site - I guess I'll have to blog about my findings on this problem too!

    Tonight I'll set up a SQL monitor on the next sop number, create an order and see if I can get it to release the number back prematurely, that will indicate where my problem is.

    I'm also going to dig into what the stored procedure gets up to (taGetSopNumber).

    Thanks for letting me think through the issue with you.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,850 Moderator on at

    I remember way back in the days of eEnterprise having a similar problem and they provided an updated script. I would only image that today they should have the latest and greatest script getting the next SOP number. Sorry about referring you to your own article but I guess that shows how popular your article is. Hopefully you will find an answer. I would be curious to know what they answer is so please keep me posted.

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…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans