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

I have the same question (0)

All responses (4)

Answers (0)

Richard Wheeler 75,852 Moderator on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
junejax 5 on at

Like (0)

Report
Copy link

Link copied!

Great Post! Thank you for visiting here.

innoutsecretmenu.online/

Was this reply helpful? Yes No
SiuKK 45 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Richard Wheeler 75,852 Moderator on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No