web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Unanswered

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) ShareShare
ReportReport
Posted on by 45

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:
I have the same question (0)
  • Richard Wheeler Profile Picture
    75,850 Moderator on at

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

  • junejax Profile Picture
    5 on at

    Great Post! Thank you for visiting here.

    innoutsecretmenu.online/

  • SiuKK Profile Picture
    45 on at

    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

  • Richard Wheeler Profile Picture
    75,850 Moderator on at

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

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

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 456 Super User 2025 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 429 Most Valuable Professional

#3
BillurSamdancioglu Profile Picture

BillurSamdancioglu 239 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans