News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) Error Message from

Microsoft Dynamics GP (Archived)

Error Message from

(0) Share

Report

Report

Posted on by mliu@inflamaxresear...

30

I got the error message below when I try to edit payable checks:

The stored procedure pmControlNumberValidate returned the following results: DBMS: 0, Miscrosoft Dynamics GP: 21032.

Now the payment number can't be populated automatically. I remember when I re-login into my user ID, one window popped up to ask me recover some payment batch. But I closed the window too quick to record what I am asked to do unfortunately. And the window reminder never comes back again.

Anyone knows how to fix this problem? Appreciated your helps in advance.

*This post is locked for comments

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Mahmoud Saadi 32,738 on at

Like (0)

Report
RE: Error Message from

This error is returned as the document number (control number) doesn't pass the validation check, which means the number already exists in PM00400.

In order to get this corrected, follow the steps below;

Run the following script on SQL to retrieve the maximum control number

SELECT MAX (CNTRLNUM) FROM PM00400 WHERE DOCTYPE=6 and CNTRLTYP = 1

Now, go to Setup > Purchasing > Payables. Options Button.

On the Next Payment Number, put in the number retrieve above + 1

Here is the support article reference on Microsoft Customer Source;

Error "DBMS: 0, eEnterprise: 21032." occurs on stored procedure PM Control Number Validate when you select Checks in Payables Management

One last point to consider, check on the batch recovery any corrupted batches, Tools > Routines > Batch Recovery.

Helpful resources

Quick Links

Leaderboard

#1

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

#2

Martin Dráb 230,214 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans