web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... eConnect

Finance | Project Operations, Human Resources, ...

Suggested Answer

eConnect

(1) Share

Report

Report

Posted on by Mohammed Rafe

58

I have This Error : /Unable to increment next document number from document type setup after 1000 attempts (RM40401)/

Categories:

Microsoft Dynamics GP

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

lancebrigham 119 on at

Like (2)

Report
Copy link

Link copied!

Hi, run this to see what current next payment number is and what current max payment number is from RM00401. You may need to update what's in RM40401 for RMDTYPAL=9 to be what should be next payment number. If it's more than 1,000 iterations behind and all 1,000 iterations are actually used, then you'll get that error you see.

SELECT DOCNUMBR
FROM RM40401
WHERE RMDTYPAL=9

SELECT MAX(DOCNUMBR)
FROM RM00401
WHERE RMDTYPAL=9

Let me know if any questions.

Thanks,

Lance Brigham

Velosio

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1

André Arnaud de Cal... 509 Super User 2026 Season 1

#2

Giorgio Bonacorsi 375

#3

Adis 268 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans