Finance | Project Operations, Human Resources, ...

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

(0) Share

Report

Posted on by xppdev

122

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

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

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.

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

I dragged the fields from the OpeningAccount to the Fields of the MainAccountEntity

After that these are the steps I did

1. Full build/sync

2. Refresh Entity List

3. Modify Target Mapping > Generate Mapping

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

Exporting

Export result

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

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

André Arnaud de Cal... 301,146 Super User 2025 Season 2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
xppdev 122 on at

Like (0)

Report

Hello Andre.

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

Update the staging table is not available on the MainAccountEntity extension

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

Thank you

Was this reply helpful? Yes No
André Arnaud de Cal... 301,146 Super User 2025 Season 2 on at

Like (0)

Report

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)?

Was this reply helpful? Yes No
xppdev 122 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Charles.sun 10 on at

Like (0)

Report

I have same issue, please do you solve it ?

Was this reply helpful? Yes No