Payables Management "Document Number Already Exists" Error

(0) Share

Report

Posted on by Chris Brand

180

Our accounts payable person, when entering a transaction through the Payables Management window gets a error pop up that states "The Document Number already exists" and then can't continue the transaction. I believe this error occurs when they try to enter in the docnumber. I've looked through the PM00400 table and found the voucher number in the CNTRLNUM field. It has no vendorid or docnumber associated with it and the due date is 1900-01-01. This happens to them at least once a week. We are on GP9 with the latest/last service pack. I've looked thru the knowledge base and all I could find is 863247. Anyone else have a problem similar to this?

Thanks,

Chris

*This post is locked for comments

All responses (2)

Answers (0)

Tariq Aziz. on at

Like (0)

Report

RE: Payables Management "Document Number Already Exists" Error

I compared the problematic transaction with normal one and found differences in 2 columns:

1. USERID

2. DCSTATUS

Updating the User ID to empty and Doc status to 1 helped me.

update a set USERID = '' , DCSTATUS = 1

from PM00400 a where CNTRLNUM = 'YOUR_PM_DOC'
Suggested answer

Richard Whaley 25,195 on at

Like (0)

Report

Re: Payables Management "Document Number Already Exists" Error

You need to rebuild the table. First backup the db. Then empty the table (Delete from PM00400). Then run checklinks and reconcile.