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

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

Rispondi

Inserisci i tuoi dati qui sotto o clicca su un'icona per effettuare l'accesso:

Logo di WordPress.com

Stai commentando usando il tuo account WordPress.com. Chiudi sessione /  Modifica )

Google photo

Stai commentando usando il tuo account Google. Chiudi sessione /  Modifica )

Foto Twitter

Stai commentando usando il tuo account Twitter. Chiudi sessione /  Modifica )

Foto di Facebook

Stai commentando usando il tuo account Facebook. Chiudi sessione /  Modifica )

Connessione a %s...