AX – D365FO – Create a Data Entity

Open Visual Studio and create a new Data Entity item “DataEntityTest”

A Wizard will opens. Choose the primary data source (i.e. VendTable). Click Next

Choose the fields you want to show in your data entity. Click Finish

Data Entity, Security Privileges and Staging Table will be created

If you set “Is Read only” to No the data entity will be valid only for Exporting data and not for import. Otherwise set value to Yes to be able to import data to the VendTable

Staging table must be generated. You can do it by right clicking Data Entity and click on “Regenerate staging table”

Synchronize database and Build the solution

Now you have to Refresh data entity to make it visible in Data Entity framework in D365FO.

Open D365FO, go to System Administrator, Data Management

Click on Framework parameters

Switch to Entity settings and click on “Refresh Entity list”. Wait until job will finish. It will take some times.

After job has finished you can search your Entity by clicking on Data Entity Tile and search the entity

Now you have to Map the Staging table fields with target Entity

Go to Data Entity, search the entity and click on “Modify target mapping”

Click on “Generate mapping”

If you click on “Mapping Visualization” you’ll see the mapping.

For convenience I have entered only one field (AccountNum)

One thought on “AX – D365FO – Create a Data Entity


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

Logo di

Stai commentando usando il tuo account 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...