AX – D365FO – How to solve the error “The natural key for the table was not found” in a Data Entity #d365fo #ax #msdyn365fo

Posted on by Marco Saad

Suppose you want to create a Data Entity fot VendCertification tablr. This table doesm’t have a unique key except for RecId (Which cannot be used)

If you try to create entity and build this error eccurs “The natural key for the table VendCertification was not found“

How to solve this problem :

  1. Create an new entity

2. In the wizard field “Data EntityName” type “VendCertification” and delete it. After that retype “VendTable” (VendTabls has a natural key)

Click Next

Seselect all fields

Change Data source from “VendTable” to “VendCertification”

Drag and drog fields datasource into Data Entity fields

Generate Staging Table and buil Project

Published by Marco Saad

3 thoughts on “AX – D365FO – How to solve the error “The natural key for the table was not found” in a Data Entity #d365fo #ax #msdyn365fo”

  1. Hi Marco. I’ve done this process as per your instructions above and seems to be OK. Just a quick question if you don’t mind. In the \properties for My new data entity … The “Form ref” attribute still remains as the “FAKE” table name. Should I change this to the Correct Table name or does that not matter? Thanks Joe

    Like

    Reply

Leave a Reply

Fill in your details below or click an icon to log in:

Gravatar
WordPress.com Logo

You are commenting using your WordPress.com account. ( Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. ( Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. ( Log Out /  Change )

Cancel

Connecting to %s