Hi everyone,
I’m trying to understand the data source for the displayed Product Name in Dynamics 365 Finance & Operations.
I join EcoResProduct to EcoResProductTranslation in SQL to retrieve names in a given language for a specific item (ItemId / DisplayProductNumber).
I have several products that exist in EcoResProduct but have no rows in EcoResProductTranslation.
The SearchName in EcoResProduct is present but not the correct name.
However, the UI still shows the correct product name on pages like Released products.
What I’ve checked:
- Looked at EcoResProductTranslation (no rows for these products).
- Looked at EcoResProduct (has SearchName, but that’s not the name the UI shows).
- Looked at EcoResProductTranslationFallbackView, but I still can’t find a persistent field that exactly matches the UI value.
- In the AOT browser I can see metadata for tables/entities, but I don’t have Visual Studio access to open X++ code.
- I’m aware that the UI might use a display method or a computed column, but I don’t know which one and where for product name.
Where exactly does D365FO source the Product Name shown in the UI when there is no record in EcoResProductTranslation for the user’s language?
Is there a standard display method (e.g., on EcoResProduct) or a computed column (e.g., on a view behind EcoResReleasedProductV2Entity) that builds this name?
If yes, what is the object/method name and where can I see it (AOT path)?
What is the fallback order used by standard D365FO (e.g., Translation → default language → SearchName → ProductNumber, or something else)?
For reporting, how would you replicate the exact UI value in SQL (any standard view or recommended COALESCE logic)?
I want to reproduce the same “UI Product Name” consistently in reporting (SQL/Power BI) and understand the authoritative source/logic.
Thanks a lot for any pointers!
