Enable Search by Product Name in Purchase Order Screen AX 2012

Question Status

M. Yoko asked a question on 14 May 2014 3:29 AM


Just I want to know how to enable the search by product name in the item number look up  in the purchase order and sales order screen

Gertjan van der Linden responded on 14 May 2014 1:22 PM

You'll need a modification for that as this field is only a 'display' field. The actual product name is saved in a separate table per language. You can however search directly on the search name.

Jerome! responded on 27 Aug 2014 9:00 AM

In AX2012 R3 you can use the keyword search for this.
Only available for sales orders though.

it1111 responded on 30 Aug 2016 2:45 AM

just change the field name in lookup method like this:

 sysTableLookup.addLookupfield(fieldNum(InventTable, NameAlias));

Setiaji Kurniawan responded on 30 Aug 2016 3:00 AM

You can use 'Search name' column for searching item using name

Abdullah Alghadban responded on 30 Aug 2016 4:21 AM

we did it by creating a view that has inventtable, ecoresproduct and ecoresproducttranslation tables respectively and then add range on the last table on langauageid with a value of your required language ... and then use this view in the form datasources with outerjoin link type with salesline or purchline tables.

and then, add the field from the view which will be searchable ...