Open Forum

Expand all | Collapse all

SOP Master numbers keep jumping around

  • 1.  SOP Master numbers keep jumping around

    GOLD CONTRIBUTOR
    Posted 10-19-2018 09:56 AM
    In the past few months, I have seen SOP Master Numbers jumping around and being reused. This is a big issue. I am not sure if someone is changing the mast number in the setup window, check links, or something else.

    Has anyone had this issue happen to them? If so, what was done to correct it?

    ------------------------------
    Chase Landorf
    Director of I.T.
    Ideal Deals, LLC dba Ideal Aluminum Products
    Saint Augustine FL
    ------------------------------


  • 2.  RE: SOP Master numbers keep jumping around

    GOLD CONTRIBUTOR
    Posted 10-19-2018 10:43 AM
    Hi Chase,

    Since master numbers are assigned for all document types its not uncommon for quotes, orders, invoices, backorders, and returns to be cancelled after creation.  You can change the document types settings to not allow document deletion (void only), to help stop this.

    Hope this helps!
    Mike

    ------------------------------
    Michael Taranto, CPA
    President
    ERP Consulting, LLC
    Pataskala OH
    740-951-0220 mtaranto@erpconsultingLLC.com
    erpconsultingllc.com
    ------------------------------



  • 3.  RE: SOP Master numbers keep jumping around

    GOLD CONTRIBUTOR
    Posted 10-22-2018 07:52 AM
    Chase,
    When you say the "SOP Master Numbers jumping around and being reused" do you mean that they are being duplicated?  As in, the same master number on two different sets of SOP orders?

    We have had this as an ongoing problem for several years.  We are currently on v2013r2 and I'm trying to remember which version we noticed this happening and I want to say it was at least 5 years ago.

    It became a nightmare trying to follow orders/backorders/invoices when there was more than one actual ORDER involved.  We got with our VAR who had me work directly with Microsoft.  While Microsoft could not provide me with an answer as to "why" this was happening, they did provide a script for me to run in order to clear it up and "reset" the master number issue.

    To our knowledge, that resolved the issue until we noticed it happening again this year and I had my IT guy run the script against our database as well as our archives.  He began monitoring it and noticed it happening on occasion so he is going to see if he can get the script to run monthly.

    I can tell you it is a very frustrating thing to deal with.  I have tried to duplicate the issue trying several order entry methods but with no success.  It's like the system has a mind of its own.  Running reconcile or check links will not resolve the issue.

    If this is your same issue, let me know and I'll email the script to you that we use.




    ------------------------------
    Pam Palmer
    Projects/Database Admin
    Temple, Inc.
    Decatur AL
    ------------------------------



  • 4.  RE: SOP Master numbers keep jumping around

    GOLD CONTRIBUTOR
    Posted 10-25-2018 01:55 PM
      |   view attached
    Attached is the script that we use to address any Master Number duplication.

    I did not write this script, it started with Microsoft but has been worked on by our IT guy.  If you have any questions, let me know and I'll have my IT guy respond.

    ------------------------------
    Pam Palmer
    Projects/Database Admin
    Temple, Inc.
    Decatur AL
    ------------------------------

    Attachment(s)



  • 5.  RE: SOP Master numbers keep jumping around

    Posted 10-22-2018 09:36 AM
    ​I have had this issue since GP10.

    We are currently running GP2015R2 and plan on going to 2018 in the next few months.

    After talking to a few people in Phoenix last week, the only conclusion we could reach is it may be related to importing orders via Econnect.

    I have used 3 different integration products over the past 10 years and we have had this issue all along.

    Are you integrating orders?  If not, you throw sand in the gears of my new theory!

    I can turn off my integration and see if the problem goes away.  I have this problem daily.

    I added the cleanup script as a scheduled off hour job to cleanup the master numbers while no one is using GP.

    Of course i cannot control the e-commerce piece as easily.  So i do it when I HOPE no one is ordering.

    ------------------------------
    Gene Levasseur
    dba
    Wilson Language Training Corp,
    Oxford MA
    ------------------------------



  • 6.  RE: SOP Master numbers keep jumping around

    GOLD CONTRIBUTOR
    Posted 10-25-2018 12:23 PM
    @Gene Levasseur We don't use anything like that. All quotes/orders are done with GP.​

    ------------------------------
    Chase Landorf
    Director of I.T.
    Ideal Deals, LLC dba Ideal Aluminum Products
    Saint Augustine FL
    ------------------------------



  • 7.  RE: SOP Master numbers keep jumping around

    Posted 10-22-2018 10:55 AM
    We've had this happen.  It's an unfortunate side affect of GP trying to be smart but ending up with undesirable results.  GP thinks if you delete the item you'd like to make that number available for reuse and we've been told that there's no way to prevent this (other than don't delete).  We reset the individual SOP Document next numbers as well as the SOP Numbers setup.  Between the two, fingers crossed, we haven't had any issues recently.



    ------------------------------
    Kristy James
    Financial Controller
    Dairyland Electrical Industries, Inc
    Stoughton WI
    ------------------------------



  • 8.  RE: SOP Master numbers keep jumping around

    Posted 10-23-2018 12:31 PM
    I always wondered this and learned about this at Summit last week! Apparently GP thinks that if you delete a record you might want to re-use that number. Not 100% about SOP, but for POP, there is a setting called Minimum PO/Receipt # in PSTL that will make sure that the numbers in POP ONLY advance and don't go backwards. I believe this blog post refers to the similar SOP function.

    https://blogs.msdn.microsoft.com/developingfordynamicsgp/2010/08/13/pstl-2010-duplicate-customer-po-numbers-in-sop-entry/​

    ------------------------------
    Audrey Forrest
    Senior Accountant and Business Analyst
    GP 2015 R2, D365 CRM V9
    CRMUG Chapter Leader - Seattle
    ------------------------------



  • 9.  RE: SOP Master numbers keep jumping around

    Posted 10-24-2018 10:08 AM
    @Audrey Forrest I looked at the link and it seems like that setup is so that we don't reuse a customer's PO number, not to stop our numbering from being reused.

    We recently brought this issue to our partner and was told that SOP doesn't have that same feature as POP has, but thanks for pointing that out!  It's really easy to turn on for POP and I wish SOP had that same capability.​  If this isn't true I would love to know which settings to change!


    ------------------------------
    Kristy James
    Financial Controller
    Dairyland Electrical Industries, Inc
    Stoughton WI
    ------------------------------



  • 10.  RE: SOP Master numbers keep jumping around

    Posted 10-25-2018 11:36 AM
    That would be a great suggestion for the Dynamics ideas board! If you end up posting it, I would be happy to upvote it to help it gain more momentum.
    Ideas List
    Dynamics remove preview
    Ideas List
    Noticeably missing are the features added in the last couple versions. Considering the user manuals are no longer being updated, it is difficult to find relevant documentation on current features. Are the "What's New" documents and various blogs the only documentation for GP these days?
    View this on Dynamics >


    ------------------------------
    Audrey Forrest
    Senior Accountant and Business Analyst
    GP 2015 R2, D365 CRM V9
    CRMUG Chapter Leader - Seattle
    ------------------------------



  • 11.  RE: SOP Master numbers keep jumping around

    GOLD CONTRIBUTOR
    Posted 10-25-2018 12:20 PM
    @Kristy James I've gone in, and check the actual SOP numbers. Those are working correctly. I wrote a script that looks at the activity tracing on the modifying Sales Order Processing setup record. I am wondering if there is a security setting that someone has, which allows them to change it, while not really knowing what they are changing. GP security is another monster in itself. ​​

    ------------------------------
    Chase Landorf
    Director of I.T.
    Ideal Deals, LLC dba Ideal Aluminum Products
    Saint Augustine FL
    ------------------------------



  • 12.  RE: SOP Master numbers keep jumping around

    Posted 12 days ago
      |   view attached

    We don't use SOP anymore but did for over a decade, during which we experienced this problem periodically (unrelated SOP documents getting assigned the same mstrnumb value).  We had a custom Sales Transaction Entry window and I always figured the problem was likely caused by the customization, but perhaps not since others have seen this issue.

    GP maintains the "next mstrnumb" in SOP40100.NXTMSTNO.  Every time we'd have a problem with unrelated SOP documents sharing the same mstrnumb value, it was because NXTMSTNO had somehow been updated to a lower value; it really should only ever increment.

    We finally fixed it for good with a trigger on the SOP40100 table (definition attached to this post).  With the trigger enabled, any attempt to update NXTMSTNO to a value lower than its current value will be replaced by an update that will simply increment it by 1.

    I never cleared this with Microsoft, but we ran with this trigger in production for at least three years on GP 2013 (after which we stopped using SOP so it wasn't needed) and never saw a recurrence of the "jumping" mstrnumb problem.

    Note that there is an implicit reliance on the fact that there is always one and only one record in SOP40100.  A statement such as "set @nxtmstno_i = (select nstmstno from inserted)" would fail if multiple rows were being updated in a table.



    ------------------------------
    Nicholas Saner
    Systems Engineer
    Gaiam, Inc.
    Louisville CO
    ------------------------------

    Attachment(s)