Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Unanswered

Trouble with data displayed from data entity

(0) ShareShare
ReportReport
Posted on by 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.

  • Daniel Mora Profile Picture
    Daniel Mora 148 on at
    Trouble with data displayed from data entity
    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:
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,969 Super User 2025 Season 1 on at
    Trouble with data displayed from data entity
    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?

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

Announcing Our 2025 Season 1 Super Users!

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

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,969 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,842 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans