Encounter the error "Duplicate document number for entity and vendor is not allowed" while there is nothing posted/created with the same document number and vendor

(0) Share

Report

Posted on by SiuKK

Hi,

We are encountering a strange error with GP that the error "Duplicate document number for entity and vendor is not allowed" is prompted, which does not allow me to enter the document number for that vendor. However, I have checked under the Transaction by vendor inquiry that the vendor does not have that document number in all "Open", "History" or "Work" status and even under the Transaction by Document inquiry, there is no such document number exist for any vendor. Can anyone suggest anything that I should check to resolve this problem?

Thank you.

Sarah

Categories:

Microsoft Dynamics GP

All responses (4)

Answers (0)

Richard Wheeler 75,848 Moderator on at

Like (0)

Report

RE: Encounter the error "Duplicate document number for entity and vendor is not allowed" while there is nothing posted/created with the same document number and vendor

The next extreme measure would have been to delete the records from the payables key master (PM00400) and then run checklinks. Also try downloading any of the SQL scripts that allow you to search for text across all tables. There is a duplicate in there somewhere.
SiuKK 45 on at

Like (0)

Report

RE: Encounter the error "Duplicate document number for entity and vendor is not allowed" while there is nothing posted/created with the same document number and vendor

Hi Richard,

Thank you for your suggestion. However, it doesn't work in my environment, so I just ask the user to add a space behind to bypass it. Thanks for the advice anyways.

Sarah
junejax 5 on at

Like (0)

Report

RE: Encounter the error "Duplicate document number for entity and vendor is not allowed" while there is nothing posted/created with the same document number and vendor

Great Post! Thank you for visiting here.

innoutsecretmenu.online/
Richard Wheeler 75,848 Moderator on at

Like (0)

Report

RE: Encounter the error "Duplicate document number for entity and vendor is not allowed" while there is nothing posted/created with the same document number and vendor

Try running check links on the payables series. Make sure you perform a backup first and have everyone out of GP.