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

Notifications

Announcements

Sign Up for Ask a Community Pro Today!
Introducing our New Video Series: Community Spotlight
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / How to deal with "...
Finance | Project Operations, Human Resources, ...
Unanswered

How to deal with "Natural key was not found"

(0) ShareShare
ReportReport
Posted on by Voltes 596

Hello,

While creating new Data Entity for my custom table, I keep getting the error : "Natural key was not found". As per my understanding is in the table it supposed to have unique key, or it's better if we have primary key as the index, however I already set this key. 

So in my Index file which is a collection of fields, is set to Allow duplicates to No. And in the table I put this index as Primary Key.

Also actually, although not too sure, I put this index key as Alternate key. The reason is only because it is one of the rule if I'm checking through think link: 

https://learn.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/data-entities/data-entity-wizard-rules

Further more is this table is still empty. 

Anyone know what is the problem ? And what actually the requirement to meet this Natural Key ?

Thanks,

I have the same question (0)
  • Shooowtek Profile Picture
    Shooowtek 843 on at

    Hi,

    The problem may be that your table uses RecId as its primary index, and the Data Entity Wizard does not support tables with a RecId-based primary key.

    If your table's architecture does not allow you to create a primary key, you can try this solution: 

    https://d365ffo.com/2021/06/28/ax-d365fo-how-to-solve-the-error-the-natural-key-for-the-table-was-not-found-in-a-data-entity/

  • Voltes Profile Picture
    Voltes 596 on at

    Hi,

    No, I didn't use RecId for this one.

    Thanks,

  • GirishS Profile Picture
    GirishS 27,829 Moderator on at

    Hi Lars Volt,

    What exactly is the issue?

    Can you elaborate on this?

    Also refer to the below thread which explains about the documentation you added.

    https://community.dynamics.com/365/financeandoperations/f/dynamics-365-for-finance-and-operations-forum/303537/what-does-natural-key-expansion-of-surrogate-foreign-keys-mean

    Thanks,

    Girish S.

  • Voltes Profile Picture
    Voltes 596 on at

    Hi Girish,

    Yes, as what I mentioned above, I created a new table, and added Index key (made of collection of fields but no RecId). I've set this key as my primary index in the table's property. Also in that Index key I set Not allow duplicates and put as Alternative key.

    While this table still empty, create Data Entity using Wizard, but still there is an error "There is no natural key"

    pastedimage1675175064068v1.png

    I read the thread, the learning docs, and some blogs couple of time actually but somehow I didn't get the correct means. 

    Thanks,

  • GirishS Profile Picture
    GirishS 27,829 Moderator on at

    Please do a build and sync of the model from the menus and try creating again.

    Also confirm that you are selecting correct table in data entity creation wizard.

    Thanks,

    Girish S.

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

News and Announcements

Sign Up for Ask a Community Pro Today!
Introducing our New Video Series: Community Spotlight

Quick Links

Responsible AI policies

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

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the December Top 10 Community Leaders!

These are the community rock stars!

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

#1
André Arnaud de Calavon Profile Picture

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

#2
Abhilash Warrier Profile Picture

Abhilash Warrier 444 Super User 2025 Season 2

#3
BillurSamdancioglu Profile Picture

BillurSamdancioglu 288 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans