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
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
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
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.
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
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
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,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (