Microsoft Dynamics AX (Archived)

Filter Item Name in On-hand Inventory form

(0) Share

Report

Posted on by Edselv Evert

435

Hi All,

Path Inventory and Warehouse management\Common\On-hand Inventory

I want to filter the Item name via Right click the field based on 'Filter by field' and 'Filter by selection' and 'Remove filter'. I will create Context method of the Item name string Edit but it's not work for me.Please suggest.

*This post is locked for comments

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

Community Member on at

Like (0)

Report

RE: Filter Item Name in On-hand Inventory form

Hi,

The ItemName is combination name of productName and productVariantName. This is display method. You ca filter the display method for that customization is required for this.

Look into the below links, may useful for you,

msddax.wordpress.com/.../filter-on-the-display-method-using-context-method

www.andesoft.net/how-to-filter-display-fields-on-a-form-on-dynamics-ax-2012

axhelpdesk.blogspot.in/.../how-to-add-filter-functionality-to.html

Was this reply helpful? Yes No
Suggested answer

Vilmos Kintera 46,149 on at

Like (1)

Report

RE: Filter Item Name in On-hand Inventory form

Use EcoResProductTranslations view, it has the product name. Can be joined to InventTable based on Product field, or to EcoResProduct.

Was this reply helpful? Yes No
Suggested answer

Hamza Bin Mushtaq 160 on at

Like (0)

Report

RE: Filter Item Name in On-hand Inventory form

Hi Edselv,

As Vilmos suggested, you can do this by using the View EcoResProductTransalations.

Try this.

Select ProductName from ecoResProductTranslatios where ecoResProductTranslatios.Product == inventTable.Product;

This will give you the name and you can use the name field in your form which ultimately make it possible for you to filter the records base on 'Filter by field' etc.

Regards,

Hamza

Was this reply helpful? Yes No