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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested Answer

Data Management Framework - Extending MainAccountEntity, MainAccount table , MainAccountStaging table. Export issue

(0) ShareShare
ReportReport
Posted on by 124

The custom fields that I created for the MainAccountEntity does not have a value after export.  Here's what I did

I extended MainAccount table to add 2 fields. FieldString1 and FieldString2
pastedimage1619100634846v3.png


Then I extended MainAccountStaging to add 2 fields  (FieldString1 and FieldString2)

pastedimage1619100702669v4.png

After that I did a full build/sync then extended the MainAccountEntity. I noticed that the Fields in the MainAccount does not have FieldString1 and FieldString2.
pastedimage1619100817834v6.png

But when I tried to search the fields I found out that it only reflects on the ParentAccount and OpeningAccount

pastedimage1619100880427v7.png


I dragged the fields from the OpeningAccount to the Fields of the MainAccountEntity
pastedimage1619101040609v8.png
pastedimage1619101050846v9.png

After that these are the steps I did

1. Full build/sync

2. Refresh Entity List

3. Modify Target Mapping > Generate Mapping
pastedimage1619101272253v12.png

as you can see FieldString1 and FieldString2 are now present.



I also extended the MainAccount form to add the 2 fields on the form and inserted a value for FieldString1
pastedimage1619101421013v13.png



Exporting



pastedimage1619101574367v14.png
pastedimage1619101600513v15.png


Export result

pastedimage1619101702647v17.png


Note: I already followed the solution for this post but still the same result.
Any thoughts?

I have the same question (0)
  • Suggested answer
    André Arnaud de Calavon Profile Picture
    303,139 Super User 2026 Season 1 on at

    Hi xppdev,

    The DynamicsFields property on the data source of the MainAccount is set to 'No'. That is the reason why they don't show up automatically. You have to add these two new fields manually to the MainAccount data source. Then you can drag these new fields to the list of fields of the data entity itself.

    When you added the new fields on the data entity, there is an option to update the staging table with the new fields.

    Don't use the fields from the opening or parent account as it will then search for the values on another account or probably these two fields are even not filled on your main accounts.

  • xppdev Profile Picture
    124 on at

    Hello Andre.

    I tried adding Field on the MainAccount data source of my MainAccountEntity extension but nothing happens
    pastedimage1619131279849v1.png

    Update the staging table is not available on the MainAccountEntity extension
    pastedimage1619131349362v2.png

    I guess that will result to an overlayering when I add my new fields on the standard MainAccountEntity.


    Thank you

  • André Arnaud de Calavon Profile Picture
    303,139 Super User 2026 Season 1 on at

    Hi xppdev,

    Apologies for a late reply. Missed your update earlier. I did do a similar update before and didn't had any issues. Does the Training model have a correct model reference to the base application model (Ledger)?

  • xppdev Profile Picture
    124 on at

    Yes it has a reference to the base application model (Ledger). Thank you

  • Suggested answer
    Charles.sun Profile Picture
    10 on at

    I have same issue, please do you solve it ? 

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

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

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

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 555 Super User 2026 Season 1

#2
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 364

#3
Diego Mancassola Profile Picture

Diego Mancassola 259

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans