Skip to main content

Notifications

Announcements

Check out the New Agent Creator Community
Announcing new navigation menus and the Engage with the Community forum!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / The default document n...
Microsoft Dynamics GP (Archived)

The default document number is invalid

(0) ShareShare
ReportReport
Posted on by Community Member

When opening the receivables transaction entry form and clicking the search glass next to number this error message pops up:

"The default document number is invalid. Please check module setup".

I ran check links against the all the receiveables tables under sales but it didn't fix the issue.

When I searched for similar issues one came open but for project accounting. They searched a bunch of different tables looking for blanks in some columns then deleted them and then adjusted the next number somehow. Hard to follow since it was for project accounting.

Anyone else had a similar issue? How can I get this fixed?

*This post is locked for comments

  • TPGPM1 Profile Picture
    TPGPM1 4 on at
    RE: The default document number is invalid

    We run into this issue sometimes and per Sumindre's response, that is the fix.

    GP will re-use a document number if it is deleted/removed from the RM keys sequence. This can sometimes cause errors, when GP attempts to re-use a number which was not fully removed from RM00401. I wish there was an application-side option to turn off the document number recycling, as it causes no end of problems for our users.

    Here's a good description of the issue: dynamicsgpblogster.blogspot.ca/.../why-does-my-next-document-number-change.html

  • Community Member Profile Picture
    Community Member on at
    RE: The default document number is invalid

    I had a similar problem with the cash receipt window. Receivable module set-up had the PMT next number as 9374. Ran this (select * from RM00401 where RMDTYPAL = 9 order by  DOCNUMBR desc) and found that the last number was indeed 9999. In the module set-up I changed the 9374 to 10000. And the problem went away. GP has this habit of resetting next numbers it seems.

  • Community Member Profile Picture
    Community Member on at
    RE: The default document number is invalid

    thanks for the link. i restored the company database with this issue into our test database and followed the guide:

    --------------

    1. Make a backup.

    2. Go to File | Maintenance | SQL.

    A. Select your Company database and eEnterprise product.

    B. Highlight the RM Key file.

    C. Mark the options to Drop table and Create Table.

    D. Click the Process option.

    This will create a brand new RM00401 table.

    3. Go to File | Maintenance | Check Links.

    A. Select the Sales Series.

    B. Run Check Links on the Receivables Open Transaction table and the Receivables Transaction History tables. This will recreate the apply records for all documents in the work, open and history tables.  Also, run check links on the Sales Work and Invoice Work tables.

    -------------

    After the check links finished i went back to the sales transaction entry form and the error is still there.

    what do i try now?

  • Community Member Profile Picture
    Community Member on at
    RE: The default document number is invalid

    Similar issue reported.

    Search on the key word "Default document number is invalid" on the given link.

    Note: Take a proper backup.

    www.albaspectrum.com/.../great_plains_ar_issues.htm

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

News and Announcements

Check out the New Agent Creator Community
Announcing new navigation menus and the Engage with the Community forum!

Quick Links

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Almas Mahfooz Profile Picture

Almas Mahfooz 3 User Group Leader

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans