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) / Order Number Sticking
Microsoft Dynamics GP (Archived)

Order Number Sticking

(0) ShareShare
ReportReport
Posted on by Community Member

Hello all

Our customer service team are experiencing a problem when creating orders, the issue only happens intermittently but it is a pain for them none the less.

Bassically user 1 will be entering an order (head details and line details filled out) and when another customer service rep goes to create a new order it generates all the information that has been created by the first user.

As I say though this is an intermittent error and not replicable so running a trace or turning on the dexsql.log is not an option. We have tried overloading the system with orders to see if we can force the issue out.

Has anyone come across this error before or have any ideas what it could be....I have checked that the system pulls the next order number from the sop40200 and it works fine 95% of the time.

*This post is locked for comments

  • Tim Wappat Profile Picture
    Tim Wappat 5,703 on at
    RE: Order Number Sticking

    I've dug out my documentation. The solution involved calling the get next sop number procedure used by econnect by hacking the get next sop number stored procedure. Also introduced a logging table that logged the used sop numbers, preventing re-issue of the same number.

    This worked fine for us but so unsupported that I'd rather not publish the details publicly, feel free to contact me directly.

    I've posted the problem analysis here:

    www.timwappat.info/.../Duplicate-sticking-sales-order-numbers-in-Dynamics-GP

  • Community Member Profile Picture
    Community Member on at
    RE: Order Number Sticking

    thanks tim glad to see that it was a known issue. I logged it with MS and on this occasion were unable to help. Which is the script the reuses the numbers?

  • Tim Wappat Profile Picture
    Tim Wappat 5,703 on at
    RE: Order Number Sticking

    Oh yes we get that exactly, on sales order processing, sales order entry. I did a bit of work on it and raised it with MS some years back with no luck. It is due to the way GP reuses unused SOP numbers and the lack of locking between sessions in SQL.
    I'll write up a blog post about it. 
    I solved it by disabling the script that reuses the numbers, but it does cause us to use up sop numbers at a high rate, as one is used up every time a user goes into the SOP Entry window.

    My original post on this:
    https://community.dynamics.com/gp/f/32/t/64371.aspx

  • Bill Campbell Profile Picture
    Bill Campbell on at
    RE: Order Number Sticking

    Sorry dont follow the response?

  • Community Member Profile Picture
    Community Member on at
    RE: Order Number Sticking

    GO is local and sql is networked, I think it might be a connection issue just not sure how it is :D

  • Community Member Profile Picture
    Community Member on at
    RE: Order Number Sticking

    I have not been able to witness the issue as it happens and when I have replicated and overloaded the system with orders i.e getting everyone who can to generate an order everything worked fine. so the sop40200 is doing its job as far as I can tell.

  • Bill Campbell Profile Picture
    Bill Campbell on at
    RE: Order Number Sticking

    An additional environment question - what hardware platform are your clients working on ?  Individual workstaions, thin client, citrix client?

    Just filling in some gaps.

  • Community Member Profile Picture
    Community Member on at
    RE: Order Number Sticking

    Joey, Did you get a chance to look into the code behaviour for the document number defaulting.  

  • Community Member Profile Picture
    Community Member on at
    RE: Order Number Sticking

    GP10. Happens for all users and there is some VBA but this has been active for years and the issue only become noticeable in last few months

  • Community Member Profile Picture
    Community Member on at
    RE: Order Number Sticking

    Joey, this is strange.  What is the GP Version?  Is this occurring in all the workstations?  Do you have any customization or 3rd party product installed for SOP entry in place?

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

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

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,865 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,723 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans