AX / Dynamics 365 For Finance and Operations blog

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

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

More Posts

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

  1. joehailey Avatar
    joehailey

    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
    1. Marco Saad Avatar
      Marco Saad

      Hi, really Idon’t know..sorry

      Like

      Reply
  2. Seema Avatar
    Seema

    Hi, Thank you for suggestion. Just a question how to we add Entity Key.

    Like

    Reply

Leave a reply to Marco Saad Cancel reply