You’re offline. This is a read only version of the page.
14,849
Dear
We had an issue today with our sales transaction entry, the SOP number suddenly skipped and jumped 4000 number and the MASTER sequence number also skipped (but not as many numbers)
it skipped several time, not just once,
This is surely is not a human error because the Master number sequence also skipped
how do you think this was caused ? any feedback would be greatly appreciated
note that our sales transaction are generated from handheld devices that our sales representatives issue
Best Regards
*This post is locked for comments
Good day,
A user called and indicated his GP screen hung and when it cleared the master number changed. Earlier this morning it was 7 digits long, now it is 6, which is what is in the SOP setup.
I have found quite a few posts with this issue, but I am not seeing any reason as to how something like this could happen.
The users are able to create orders and subsequently invoice them, am I going to have issues when there are duplicate master numbers? We are at GP 2013.
Regards,
Rosemary
Dear
We do have several customers having this problem whereby the Master Number reset to a number much earlier and causes the entire Sales Order Processing system halted until we find the last number to reset the master number. This had been happening like once or twice a month.
These few customers do not have any customization, nor are they integrating any SOP from any 3rd party system. They are all on GP 2013 R2.
Can we know how we can troubleshot the causes of the problem and eliminate the problem from happening?
Appreciate feedbacks from all.
Thanks
May
What version on your on?
Just following up on this case, please let us know if you do need any further assistance or whether this is fully resolved.
Your feedback is highly appreciated,
The script provided by Mariano is helpful in determining the related SOP documents in terms of master number, it enhances the use of recursive CTEs to identify the problem
Furthermore, you should proceed to solve solve the problem, and that is done on the database level. For that, you need to consider the following:
SOP Master Numbers not being assigned properly
I do remember that Microsoft has published an article as related to this issue, article ID 856311
My advice would be to technically track down the source of the problem, and check your integration accordingly to ensure that no future cases shall arise.
Let us know if you have any further inquiries,
N.W.
I have observed the same master number being given to 2 SOP documents at the same time. I have also seen a master number of zero being given when the master number tracking setup is set to track master numbers. There have also been cases where the master number has been reset by badly formed Gotos in SmartList.
Since you have mentioned your Sales Transactions are generated from handheld devices, I think I would start with their Technical Support. I have not seen the behavior you're describing in SOP (I have seen it in POP) in a regular Dynamics GP environment. However, it would be definitely something that could happen with a foreign system (handhelds) interacting with the normal Dynamics GP activity.
Tim
Dear Mahmoud
Thank you for your useful link , i would appreciate it a little clarificaiton
so the above SQL script shows the below
but how is the issue supposed to be resolved?
You are totally right, this is not a user error, I have been to this issue and Mariano article and script got me on the safe side. Check it out on Using T-SQL and recursive CTE to find related sales documents
Your feedback is highly appreciated,
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (