Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Sales document numbers...
Microsoft Dynamics GP (Archived)

Sales document numbers not generating

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

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

  • Nizamudeen Profile Picture
    Nizamudeen 790 on at
    RE: Sales document numbers not generating

    HI Richard

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

  • Suggested answer
    Cindy Joseph-Sandau Profile Picture
    Cindy Joseph-Sandau on at
    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!

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Sales document numbers not generating

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

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    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.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Sales document numbers not generating

    Beat,

    We rarely run reconcile or check links

  • Suggested answer
    Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,021 Super User 2024 Season 1 on at
    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...

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans