Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Data Management Framew...
Finance | Project Operations, Human Resources, ...
Suggested answer

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

(0) ShareShare
ReportReport
Posted on by xppdev 120

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?

  • Suggested answer
    Charles.sun Profile Picture
    Charles.sun 10 on at
    RE: Data Management Framework - Extending MainAccountEntity, MainAccount table , MainAccountStaging table. Export issue

    I have same issue, please do you solve it ? 

  • xppdev Profile Picture
    xppdev 120 on at
    RE: Data Management Framework - Extending MainAccountEntity, MainAccount table , MainAccountStaging table. Export issue

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

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 293,278 Super User 2025 Season 1 on at
    RE: Data Management Framework - Extending MainAccountEntity, MainAccount table , MainAccountStaging table. Export issue

    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
    xppdev 120 on at
    RE: Data Management Framework - Extending MainAccountEntity, MainAccount table , MainAccountStaging table. Export issue

    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

  • Suggested answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 293,278 Super User 2025 Season 1 on at
    RE: Data Management Framework - Extending MainAccountEntity, MainAccount table , MainAccountStaging table. Export issue

    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.

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,278 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 232,011 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans