Sales document numbers not generating

(0) Share

Report

Posted on by Community Member

I am having an issue with regard to sales transaction entry, lately when our sales staff start entering an order and the system tries to generate a new order number it has been hanging and then pops the “A unique document number cannot be found” error and I have to go into the sales order process setup and reset the order numbers. This has been happening all too frequently lately, and just today invoice numbers were being generated for order numbers, might anyone have a clue as to what may be happening?

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Beat Bucher GP Gee... 28,058 Moderator on at

Like (0)

Report

Re: Sales document numbers not generating

Hi Fred,

How much ofthen in the year do you run a Sales document reconcile and a check-links on the SOP module ? Microsoft advises to run reconcile at least once a month (part of your monthly routines) and the Check-links once or twice a year to fix corrupted documents... the behavior you're reporting sounds like something that could be fixed by either one of the routines...

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Re: Sales document numbers not generating

Beat,

We rarely run reconcile or check links

Was this reply helpful? Yes No
Richard Wheeler 75,848 Moderator on at

Like (0)

Report

Re: Sales document numbers not generating

I would look at your SOP30200 table. It sounds like you are bumping into sales order numbers that have already been used. It could also be your sales document numbers are not wide enough to handle the next order number. Tools->Setup->Sales->Sales Order Processing->Sales Document Setup and pull up for Doc Type ID. Make sure you have enough characters to cycle to the next number. (e.g. SOP0100, would only allow you to go to SOP9999 it will not go to SOP10000). There may also be gaps in your SOP numbers which you will find by looking at the SOP3020 table. Try running this script: SELECT SOPNUMBE from SOP30200 order by SOPNUMBE desc. This will at least show you the highest SOPNUMBE used, this is assuming you SOPNUMBE are all of the same length.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Re: Sales document numbers not generating

Is there a list of Maintenance routines and frequencies I should be running?

Was this reply helpful? Yes No
Suggested answer

Cindy Joseph-Sandau 2 on at

Like (0)

Report

RE: Sales document numbers not generating

We were having the same problem and Richards post was the solution. Orders and Invoices both had a next number of one digit, ex 9, so it wouldn't increment. We changed it to 00000000010 on both and it worked. Thanks!

Was this reply helpful? Yes No
Nizamudeen 790 on at

Like (0)

Report

RE: Sales document numbers not generating

HI Richard

After doing all these still i have same Problem ,will you please Suggest me some other.

Was this reply helpful? Yes No