Display Product Name in a Item Id Lookup

(0) Share

Report

Posted on by Swetha Molagavalli

197

Hi Everyone,

I have requirement to display the Product Name in Item Id lookup. I have tired by adding EcoResProductTranslation datasource field is showing as Item Type instead of Product Name and also used defaultProductName(),ProductName()

Can anyone please tell me to display the Product Name

Regards,

Swetha

*This post is locked for comments

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Chaitanya Golla 17,225 on at

Like (0)

Report

Hi,

You need to add datasource EcoResProductTranslation to your query(if you already have EcoResProduct) and use field DisplayProductNumber of table EcoResProduct through following relations.

Relations:

InventTable.Product == EcoResProduct.RecId

EcoResProductTranslation.Product == EcoResProduct.RecId

If language is not EN-US, then you have to combine LanguageTable to EcoResProductTranslation through relation EcoResProductTranslation.LanguageId == LanguageTable.LanguageId and use field Name of table EcoResProductTranslation.

X++ Code: EcoResProduct::find(this.DistinctProductVariant).productName(_languageId);

Hope this helps you.

Was this reply helpful? Yes No