SOP Entry window cannot find unique number

(1) Share

Report

Posted on by Community Member

I have users going in the SOP entry window, when they tab to document number field, many times they get a blinking hourglass and eventually a message saying "A unique document number could not be found. Please check setup"

Any ideas what might be causing this problem and how to resolve it.

Thanks.

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (0)

Dave Drlich 85 on at

Like (0)

Report

Re: Re: Re: Re: SOP Entry window cannot find unique number

Richard,

Is that stored procedure written for a particular Dynamics GP version or range of versions? I wasn't able to find any corresponding information in the Microsoft KB, which I find to be an annoyance. There have been more than a handful of occasions where I've opened a support case and found that it's a known issue to them but that nothing has been published to help customers or partners.

Thanks!

Dave

Was this reply helpful? Yes No
Richard Whaley 25,195 on at

Like (1)

Report

Re: Re: Re: Re: SOP Entry window cannot find unique number

When you have a large number of orders in the system (in work and history) your master numbers will start to have holes in the sequence when orders are deleted. The system tries to fill these holes. Problem is, the next number is then set to something that exists. When you try to add the next order, it sees the next number is used, steps forward 1, and checks again. It repeats this test, one step at a time ONLY 100 times and then gives the error message above.

You need to get an updated stored procedure and you can find it on our web site in Tips and Tricks Archive at www.AccoladePublications.com

Was this reply helpful? Yes No
Victoria Yudin 22,768 on at

Like (0)

Report

Re: Re: Re: SOP Entry window cannot find unique number

Unfortunately, there is no one answer to what would cause this to keep happening. Do you have customizations or add-ons in GP? Can you reproduce this at will? If you have GP installed on the SQL Server, can you see if you can reproduce it there? If you're not using master numbers, an option may be to turn them off.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Re: Re: SOP Entry window cannot find unique number

Victoria, thanks for your reply. I had seen an aritcle and set the master numer in SOP setup to a higher number that the query returns. However, that number seems to reset back to a lower number after users use the system. Any idea how that happens and how I can prevent that from happening?

Thanks

Was this reply helpful? Yes No
Victoria Yudin 22,768 on at

Like (0)

Report

Re: SOP Entry window cannot find unique number

I have seen this happen when the next master number was set to be something that has already been used. You can check the next master number by navigating to Tools > Setup > Sales > Sales Order Processing. To see the highest number used on a transaction, you can the the following query in SQL:

select MAX(a.MSTRNUMB) from (select MSTRNUMB from SOP10100 union all select MSTRNUMB from SOP30200) a

Was this reply helpful? Yes No