Announcements
No record found.
This is an oldie but goodie that I thought had long been fixed. Every now and then when users go to create a new SOP document the number that is generated is an old number. What is happening is GP is trying to fill in gaps in the sequence. Is there a different stored procedure I can load that will not behave this way?
Hello Richard,
Thank you for your post and I look forward to all the great feedback others in the community will be able to offer.
Would you in the meantime offer some further details around this?
How are SOP documents being brought into GP?
Is this all SOP documents or specific types?
When the system reverts to this older number, do you need to go into the system and reset it? or does it auto jump back to the next available number?
Is the number you talking about the document number and/or master number?
I look forward to your feedback when available.
Take care,
Nicole Fiskum
Nicole, we are talking about the SOPNUMBE not the MSTRNUMB. These are data entry people just typing away. One user will notice that an old order number has been assigned while others have the most recent number. The next time this same user goes to create an order the more recent number in sequence will be assigned. I remember back in the 1990's we were given a revised script to correct this. Alas, I have been unable to find that script.
For others picking this up through search, this is normal behaviour for GP, the application attempts to reuse numbers that have not been consumed, say the user went into the document number field, so was issued with a number, but just closed the window and never used it.
As I understand it this activity happens in both stored procedures for eConnect and in DEX too for the user interface forms.
I've not seen the script(s) you refer to though.
Tim.
Tim, we first noticed back in the 1990's. I remember being sent a script that did not behave this way. I am unable to find it. What I will do is create a script to find the gaps and fill them in. The same client who complained about this then is complaining about this now.
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.
Congratulations to our 2026 Super Stars!
We are thrilled to have these Champions in our Community!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
André Arnaud de Cal... 586 Super User 2026 Season 1
Giorgio Bonacorsi 551
CP04-islander 408
