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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Supply chain | Supply Chain Management, Commerce
Answered

Vendor Certification Expiration Date Update

(1) ShareShare
ReportReport
Posted on by 2

Is there a Data entity that I can use to update vendor certification expiration date for multiple vendors at once?

I have the same question (0)
  • Suggested answer
    nmaenpaa Profile Picture
    101,172 Moderator on at

    There is no data entity for VendCertification table. You can find such things out by using the "Find references" feature in Visual Studio - just right click the table, Find references and check if you see any data entities in the result.

  • Suggested answer
    Satish Panwar Profile Picture
    14,673 Moderator on at

    Hi Mohammed,

    VendVendorCertificationTypeEntity is available to store the certification type but as Nikoloas mentioned, the entity for VendCertification table is still missing.

  • Mohammad Al Hendawi Profile Picture
    2 on at

    Thank you Nicolaos for your contribution.

    Is there a workaround to update the expiration date for multiple vendors?

  • Suggested answer
    nmaenpaa Profile Picture
    101,172 Moderator on at

    Yes, you just need to develop your own data entity for that table.

  • Mohammad Al Hendawi Profile Picture
    2 on at

    Excuse me for being too needy, but can you provide me with some article to see how to define the new entity?

  • Suggested answer
    Satish Panwar Profile Picture
    14,673 Moderator on at

    Here you go. It has detailed example:

    docs.microsoft.com/.../build-consuming-data-entities

  • Mohammad Al Hendawi Profile Picture
    2 on at

    Hello Satish,

    Thank you for your response, when I went through the steps and chose VendCertification for the data entity creation I received an error "The natural key is missing for VendCertification..."

  • Verified answer
    Satish Panwar Profile Picture
    14,673 Moderator on at

    Take a look at different links below and try to see what you can use. Suggest that you follow link below:

    community.dynamics.com/.../natural-key-not-found-when-creating-a-custom-data-entity

    The 2nd link is just a workaround:

    stoneridgesoftware.com/.../

  • Suggested answer
    nmaenpaa Profile Picture
    101,172 Moderator on at

    Data entity can be only created for table that has a natural key. So perhaps this explains why Microsoft hasn't created entity for this table. The natural key is needed to determine whether an insert or update should be performed when data is imported using the entity.

    You can't add natural key to an existing table using extensions. So in this case you would need to develop a new table, that would be a copy of the vendor certification table, but which would also have a natural key. The natural key (unique index) can for example consist of all fields in the table.

    Then, create entity for this new table. Now you can import data to your new table. Finally you need to develop some logic that iterates your new table and inserts the data from your table to VendCertification table.

  • Raquel GP Profile Picture
    5 on at
    Microsoft has already published a entity for certifications VendCertificationV2Entity, with property IsReadOnly=No, but without key, it does not work for import/update several records.

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

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Supply chain | Supply Chain Management, Commerce

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 190 Super User 2026 Season 1

#2
Laurens vd Tang Profile Picture

Laurens vd Tang 112 Super User 2026 Season 1

#3
Subra Profile Picture

Subra 107

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans