Finance | Project Operations, Human Resources, ...

SOP Document next number

(1) Share

Report

Posted on by BeckyP77

Hi,

I have a customer that started having issues getting the next number on SOP documents last Thursday. They are using next number by SOP Type and it either comes up with the message below or is really slow to return a number.

There was a server update on the 2nd but this started 2 days later.

I have restarted the server in question and also run dbcc checkdb.

This issue is intermittent. Has anyone come across this or know the solution? The client is getting frustrated as it's halting invoice processing.

They are on version 18.4.1436 and have been for a while with no recent GP changes.

Thanks

Becky

Categories:

Microsoft Dynamics GP

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

David Musgrave MVP ... 14,076 Most Valuable Professional on at

Like (0)

Report

SOP Document next number

Check the SOP Inquiry window to see what the highest number for that document type. Or look at SOP tables via SQL.

Then check the next number in SOP Setup.

If it is more than a 1000 numbers back from the next available number you will go that error.

This issue can occur if a document is created and left in work for a long time, then deleted. This will return an old number to be used. Once used, the jump to the next unused number is more than the allowed gap.

The gap limit exists to prevent extremely long pauses getting the next number.

You just need to reset the next number and avoid keeping transactions in work a long time before deleting them.

Regards

David

Was this reply helpful? Yes No
Suggested answer

Lisa at AonC.com 878 Super User 2025 Season 2 on at

Like (0)

Report

SOP Document next number

Is their Document ID numbering sequence possibly "full"? (For example, they were at ORD99999 and next number would be ORD100000 but GP does not by design add characters to the string.)

You can review your existing document numbers with SmartList > Sales > Sales Transactions and search for the Document ID (NELINV) that is associated with the error. here is a screenshot of that SmartList Search:

You can view the Next Number by navigating to Microsoft Dynamics GP > Tools > Setup > Sales > Sales Order Processing, drilling into the Document Defaults - looks like it is Invoice ID - and then select the Document ID (NELINV) associated with the error.

Here is a screenshot from the sample company:

There is an old post about this here: SOP Entry window cannot find unique number

Reply with more details/findings if this doesn't resolve the issue.

Was this reply helpful? Yes No
BeckyP77 18 on at

Like (0)

Report

SOP Document next number

@Lisa at AonC.com the number series all start with a 1 or 3 by document number so i don't think it's that but will check. Thank you.

Was this reply helpful? Yes No
BeckyP77 18 on at

Like (0)

Report

SOP Document next number

https://community.dynamics.com/profile/?userid=09b82f7b-5e23-e811-8189-e0071b6ac181 thanks Dave, i'll take a look and revert back.

Was this reply helpful? Yes No