Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance forum / Cannot create a record...
Finance forum

Cannot create a record in Vendors (VendTable). Vendor account: VEUR000941. The record already exists. Show diagnostic

(0) ShareShare
ReportReport
Posted on by Finance and operations

Hi, users are trying to create a new vendor.
They are facing to the following error. "Cannot create a record in Vendors (VendTable). Vendor account: xxxxxx. The record already exists"
When I go to Organisation administration\number sequence\ Manual cleanup (option current) and execute the cleanup, the problem is resolved and the vendor is created, but during the next vendor creation, the problem is back.
Is Sandbox, I changed the continuous from YES to NO and I am not getting any issue.
Is this the correct action to do.
If yes, is there any negative impact to change this parameter now (not on day one)

Note: We are using D365 v8.1.3 Platform 23.
Thank you !

Categories:
Financial Management
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 293,274 Super User 2025 Season 1 on at
    RE: Cannot create a record in Vendors (VendTable). Vendor account: VEUR000941. The record already exists. Show diagnostic

    Thanks Rahul,

    Usually, I never recommend to use the continuous option for master data. It could be indeed a 'gimmick' of 8.1.

  • Suggested answer
    Community Member Profile Picture
    Community Member on at
    RE: Cannot create a record in Vendors (VendTable). Vendor account: VEUR000941. The record already exists. Show diagnostic

    had seen similar situation with another project and we had to remove continuous numbering specially when upgrading from 7.3 to 8.1

  • Finance and operations Profile Picture
    Finance and operations on at
    RE: Cannot create a record in Vendors (VendTable). Vendor account: VEUR000941. The record already exists. Show diagnostic

    Hi André,

    I has a look and the grid is empty. Do you think by changing the parameter to non continuous can resolve the issue, if so, can we do the change any time with no impact ? or do you see any other solution?

    Thank you !

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 293,274 Super User 2025 Season 1 on at
    RE: Cannot create a record in Vendors (VendTable). Vendor account: VEUR000941. The record already exists. Show diagnostic

    Hi Kamel,

    Did you check the status list related to the vendor number sequence? It could be the case that due to a bug the used numbers were stored in the list. If so, delete all records with numbers which are already in use by existing vendors.

  • Finance and operations Profile Picture
    Finance and operations on at
    RE: Cannot create a record in Vendors (VendTable). Vendor account: VEUR000941. The record already exists. Show diagnostic

    Hi André

    It is not a new implementation, we were able to create new vendors since last year, then suddenly we are facing to the issue.

    To response to your question, we migrated the vendors using a tool (similar to data management) and I am doing a cleanup beside the 24h automatic cleanup.

    Thank you !

    Kamel Sadek.

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 293,274 Super User 2025 Season 1 on at
    RE: Cannot create a record in Vendors (VendTable). Vendor account: VEUR000941. The record already exists. Show diagnostic

    Hi Kamel,

    The continuous setting on number sequences is intended to be used for invoice and voucher numbers and all that is legally required to have no gaps. In my opinion, you don't need it activated for vendors. However, it should work continuous without issues. Can you check if the number sequence still has a status list with numbers? If so, you can delete them to prevent this issue. Do you have customizations in this area or did you import vendors using e.g. data management?

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,274 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,933 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans