Can anyone tell me How can i use product name as filter in planned order grid in D365?
I have tried by adding the relation in Ecoresproducttranslation but i couldn't able to add languageid filter it results in Duplicated records of language..
Please tell me the possibilities?
Can you give us more information, please?
You've asked in the developer forum, therefore I'm assuming you're building a customization, not just setting a filter in GUI.
Why aren't you able to add a filter for LanguageId?
The ReqPO table contains the field called Product.. But it doesn't have a field for language... So I can only releate with product.
Off course it doesn't. The point is that you can display names translated to user's or client's language. If two users look at the same item, they can see different names - e.g. one in English and one in Chinese. If the language was defined on the other, all users would see the same name.
Choose the language you want to use for filtering and filter by it.
The following code is used for the product name display method in PO grid.
public display EcoResProductName productName()
return EcoResProductTranslation::findByProductLanguage(this.Product, SystemParameters::getSystemLanguageId()).Name;
The Language in system parameter, company and the user language is en-US.
But the grid shows the product name which is of language ru - russian.