Trouble with data displayed from data entity

(0) Share

Report

Posted on by Daniel Mora

148

Hi,

I'm new with data entities in D365FO and I need to extend the EcoResReleasedProductV2Entity to add two data sources so I can add 2 new fields from those data sources. I added EcoResProductTranslation and EcoResCategory from which I needed the Name field from both data sources so I can add ProductName and CategoryName to the extended entity and also to the extended staging table. I build the project with no errors but when I check the SSMS it appears this way:

Meanwhile, on the environment, with the company MXMF it only shows these ones:

In the SSMS I couldn't find any ProductName in spanish which are the ones that appeared on my environment and also every CategoryName is NULL. In the case of CategoryName I'm guessing is due to the fact that there wasn't a previous relation between entities and I tried creating one, and in the case of ProductName there was an existing relation between the entity and EcoResProductV2Entity which has that field ProductName:

Please help. Thanks in advance.

I have the same question (0)

All responses (2)

Answers (0)

André Arnaud de Cal... 303,314 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi Daniel,

If you need the Spanish translations, did you set a range on the Language field next to a relation on the product?

Related to the category name, can you share what exactly you have extended? What exact category name do you need? The name of the category linked to the product as retail category or another?

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

Like (0)

Report
Copy link

Link copied!

Hi Andre,

How do I set that range up? Because ProductName comes from the datasource EcoResProductTranslation - Field: Name. But when checking that table in the SSMS, in the LanguageID column, there is no spanish. And also, I have more than 15000 products there but in the MXMF company there are only 15 products.

Regarding the CategoryName, I extended the entity EcoResReleasedProductV2Entity to add the datasource EcoResCategory in which there is a field "Name", so I added that field to the extended entity and rename it as CategoryName. Since I saw everything was as Null, I tried to make a relation on the extended entity with the entity in which that same field is being utilized (EcoResProductCategoryEntity):

And yes, is the category related to the product as retail category, here are examples:

Was this reply helpful? Yes No