Try Microsoft Edge
A fast and secure browser that's designed for Windows 10
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
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.
In AX2012 R3 you can use the keyword search for this.Only available for sales orders though.
just change the field name in lookup method like this:
You can use 'Search name' column for searching item using name
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 ...
@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????
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.