How can I add data sources to an extended data entity without increasing its records.

(1) Share

Report

Posted on by Daniel Mora

148

Hi,

I have the EcoResReleasedProductV2Entity which has 15 records in a DataAreaId which I'm currently working on. I need to add 2 fields to that entity (ProductName, CategoryName) so I extended the data entity and added these 2 data sources: EcoResProductCategoryAssignmentEntity and EcoResProductTranslation. But when I add these datasources, it appears it takes all the records from within those data sources and it increases and duplicates the records in the entity I extended.

So when I check the entity again, I dont have just 15 records, I have like 200K and more. I just need to add those fields with their proper value and that it shows acoordingly with those 15 records. How can I do this? I think it might be with how those data sources relate to the entity but don't know exactly how to configure it or change it.

Thanks in advance.

Here are the data sources:

I have the same question (0)

All responses (4)

Answers (0)

GirishS 27,827 Moderator on at

Like (0)

Report

How can I add data sources to an extended data entity without increasing its records.

Hi Daniel,

EcoResProductTranslation will have many records for same product in different languages. You can use EcoResProductSystemLanguage table will have product with current system language id.

So, try adding EcoResProductSystemLanguage table inside the DataSource of EcoResProductTranslation table and check.

Thanks,

Girish S.

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

Like (1)

Report

How can I add data sources to an extended data entity without increasing its records.

Hi Daniel,

It is al about setting the correct relations on the data sources. As mentioned by Girish, there can be multiple translations for a single product. One product can also have multiple category assignments. Instead of adding the data sources, you can also consider virtual fields: Computed columns and virtual fields in data entities - Finance & Operations | Dynamics 365 | Microsoft Learn

Was this reply helpful? Yes No
Daniel Mora 148 on at

Like (0)

Report

How can I add data sources to an extended data entity without increasing its records.

Thank you Girish and Andre for answering.

Unfortunately, I tried both things and adding EcoResProductSystemLanguage table inside the DataSource of EcoResProductTranslation table didn't work, it also increased its records and also Product in the EcoResProductSystemLanguage is just a number, not the name and it doesn't have any field as Name. I even noticed that just the fact of adding the data source does this without me adding any field. So then, I tried adding a computed field as Andre suggested but it won't let me add a new method even though is an extension of the entity:

On a side note, I don't know why the new updated forum won't let me reply directly to your responses.

Was this reply helpful? Yes No
GirishS 27,827 Moderator on at

Like (0)

Report

How can I add data sources to an extended data entity without increasing its records.

Refer to the below blog for adding an virtual field through extension.

https://usdynamics365.wordpress.com/2020/04/12/data-entity-create-virtual-field-microsoft-dynamics-365-for-finance-and-operations/

Thanks,

Girish S.

Was this reply helpful? Yes No