Add column to ItemID EDT lookup

(1) Share

Report

Posted on by Community Member

Hello,

I want to add column of ItemName in the lookup of EDT ItemdId. ItemdID has the InventTable in Reference Table property. I have checked all the Field Groups of InventTable but couldn't find any solution to my problem. Please tell from where this lookup is being filled.

Help will be highly appreciated.

Thanks

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (3)

Suggested answer

Florian Hopfner 2,457 on at

Like (0)

Report

RE: Add column to ItemID EDT lookup

ItemName is not a field that is directly available in InventTable. Instead it lives in the EcoResProductTranslation table, which handles the translation texts of a product. This is why you can't find the field in any of the field groups of InventTable.

We solved this problem by building a view that uses a computed column to display the item name. This view is used as the data source of a custom lookup form for ItemId fields.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Add column to ItemID EDT lookup

Hello @FH-Inway,

you got me a little wrong. Lets say i want to add field AltItemId that is the part of InventTable to ItemId lookup, what will i do? where will I add the ref or code of it?

Was this reply helpful? Yes No
Verified answer

Sohaib Cheema 48,889 User Group Leader on at

Like (0)

Report

RE: Add column to ItemID EDT lookup

if lookup is not appearing by code, in that case it is automatically created using AutoLookup FieldGroup of specific Table.

Try to add all your needed fields under \Data Dictionary\Tables\InventTable\Field Groups\AutoLookup

if there are no fields already, don't worry about that. add there fields which are coming now as part of existing lookup+New Fields which you need.

in otherwise case its needed to modify lookup by code (in case if lookup appearing through code)

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Add column to ItemID EDT lookup

Thanks alot @sohaib.

I was thinking of adding fields to autolookup already but i didnt because it was empty. Now when I did it is showing the fields added. The question is answered. :)

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Add column to ItemID EDT lookup

Hello @sohaib,

I have added a display method 'ItemName' from Methods node of InventTable to AutoLookup. Now my product name is showing but i want it to be searchable like If i press Ctrl+G it should search it. But display method is not allowing me search. Please suggest what to do?

Was this reply helpful? Yes No
Verified answer

Florian Hopfner 2,457 on at

Like (0)

Report

RE: Add column to ItemID EDT lookup

You should decide if you want to show AltItemId or ItemName in the lookup. If you want to show ItemName and make it searchable, see my previous answer for a possible solution.

Was this reply helpful? Yes No
Verified answer

Sohaib Cheema 48,889 User Group Leader on at

Like (0)

Report

RE: Add column to ItemID EDT lookup

Simple answer to that is, it is needed to customize, and you need to override lookup method, instead of relying on standard lookup by AutoLookup.

As dynamics ax is Multi-language ERP system, in terms of usage, so names and description of products can exist in multiple languages.

One product/item may has N names/description based on Language. Due to this the name/description of product is not saved in InventTable. Instead, the name/description of Product is saves in EcoResProductTranslation.

In table EcoResProductTranslation there can be N/multiple records for 1 record of InventTable.

As any user, opens AX, the item name/description which is appeared in front of him/her is based on his language of preference (Set-up in user options)

Due to above structure Microsoft has kept this field non-searchable at most of lookups. If you open main form or list page of released products, you will find Product searchable by Item/ Product name. if you will drill-down the query of that list page and associated ListPageInteraction class, you would find how it is applying range of language-id at load of list page.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Add column to ItemID EDT lookup

@FH-Inway , AltItemId i just said for an example. I needed ItemName that i have retrieved by method in inventtable. But to make it searchable I guess i have to go with your solution you told earlier.

Was this reply helpful? Yes No