AX Technical Tip #4: Filter Data by Individual or Multiple Fields

AX Technical Tip #4: Filter Data by Individual or Multiple Fields

Microsoft Dynamics AX gives users the power to filter data by individual or multiple fields.  To filter by a single field, right click in the field and select “Filter by field.”  To filter by a group of fields, Press CTRL + G and enter multiple criteria.

With Microsoft Dynamics AX, users have the ability to filter by numbers, words and/or dates. For example:

1..10 finds all the values from 1 through 10

1/1/2009..12/31/2009 finds all dates between 1/1/09 and 12/31/09

!Smith finds all except “Smith”

..1000 finds any number less than or equal to 1000

1000.. finds any number greater than or equal to 1000

<1000 finds any number less than 1000

>1000 finds any number greater than 1000

A,D finds “A” and “D”.


manufacturing, ERP, Microsoft Dynamics, AX Technical Tip, Microsoft Dynamics AX ERP, criteria, fields, filter, Microsoft Dynamics ERP