SOP Number and Master Number Skipped

(0) Share

Report

Posted on by Abdo Khoury

14,855

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

I have the same question (0)

All responses (8)

Answers (0)

Suggested answer

Mahmoud Saadi 32,738 on at

Like (0)

Report

RE: SOP Number and Master Number Skipped

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,

Was this reply helpful? Yes No
Abdo Khoury 14,855 on at

Like (0)

Report

RE: SOP Number and Master Number Skipped

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?

Was this reply helpful? Yes No
Suggested answer

Tim Foster 8,515 on at

Like (0)

Report

RE: SOP Number and Master Number Skipped

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

Was this reply helpful? Yes No
Suggested answer

Mahmoud Saadi 32,738 on at

Like (0)

Report

RE: SOP Number and Master Number Skipped

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,

Was this reply helpful? Yes No
Mahmoud Saadi 32,738 on at

Like (0)

Report

RE: SOP Number and Master Number Skipped

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,

Was this reply helpful? Yes No
Laura Peters 507 on at

Like (0)

Report

RE: SOP Number and Master Number Skipped

What version on your on?

Was this reply helpful? Yes No
Yoke May 330 on at

Like (0)

Report

RE: SOP Number and Master Number Skipped

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

Was this reply helpful? Yes No
Rosemary 10 on at

Like (0)

Report

RE: SOP Number and Master Number Skipped

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

Was this reply helpful? Yes No