Enable Search by Product Name in Purchase Order Screen

Question Status

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

Hi,

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

Reply
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.

Reply
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.

Reply
it1111 responded on 30 Aug 2016 2:45 AM

just change the field name in lookup method like this:

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

Reply
Setiaji Kurniawan responded on 30 Aug 2016 3:00 AM

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

Reply
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 ...

Reply
@NoMe responded on 30 Apr 2017 2:48 AM

@Abdullah Alghadban. I have done same thing as you told. I made a view from Inventtable,ecoresproduct and ecoresproducttranslation and dragged it in purchline form datasource with inner join with purchline. but whenever i select any item the view field does not show any product name. It is empty.But for already created lines it is showing product name. Can any one help????

Reply
Suggested Answer
magic1949 responded on 30 Apr 2017 7:21 AM

Search name is usually the best option because it is an indexed field, and thus the search is  faster.

However, these days searching within a category hierarchy is usually much easier for the end user.

(It will also then usefully display the category on the PO line (but does not show in the transaction tables, nor on receipt) Category is designed for non-stock purchase but for product selection of an item code it works fine if you set up the relevant category hierarchy.

Reply
Suggested Answer
magic1949 responded on 30 Apr 2017 7:21 AM

Search name is usually the best option because it is an indexed field, and thus the search is  faster.

However, these days searching within a category hierarchy is usually much easier for the end user.

(It will also then usefully display the category on the PO line (but does not show in the transaction tables, nor on receipt) Category is designed for non-stock purchase but for product selection of an item code it works fine if you set up the relevant category hierarchy.

Reply