Armanino Blog

Where has the advanced filter in AX 2012 gone?!

June 05, 2012

Although there are a myriad of vast improvements with the user interface in AX2012 from its predecessors, the new streamlined forms have fewer filtering icons and menu commands available in comparison to AX2009. Microsoft has attempted to simplify the screens by moving some of the classic toolbar features to the bottom left portion of the forms.

No Filter Icon

However, missing from this are the filtering icons most will recall from AX2009. Many super-users and AX implementers will recall how often such filtering was needed—particularly the advanced filter. While the grid filter is still accessible in the user options and the field filter is still available via right-click, the advanced filter is notso easily accessible.

To access the advanced filter in Dynamics AX2012, the user will need to press Ctrl + F3 on the keyboard. This key command will open the traditional "advanced filter" query criteria form, familiar from the past several versions of AX. As a reminder, this filtering technique is frequently utilized to handle the application of filter criteria relating to tables and fields not directly displayed in the current form, but relevant for restricting the user's view of the data.

Purchase Order

Don't let the use of one of the most powerful tools Dynamics AX offers go to waste simply because it is harder to find. Remember Ctrl + F3 is your ally the next time you need to utilize advanced filtering in Dynamics AX2012!

Stay In Touch

Sign up to stay up-to-date with the latest accounting regulations, best practices, industry news and technology insights to run your business.

Related News & Insights
General Contractor Trends to Consider in 2022 Webinar
Hear from experts how you can better manage your subcontracts — and more.

December 16, 2021 | 10:00 AM - 11:00 AM PT
Women in Nonprofit Leadership Panel
Aspiring nonprofit leaders should hear the insightful stories of these women industry leaders to empower their journeys.

December 14, 2021 | 10:00 AM - 11:00 AM PT
The Evolution of Gaming Companies
From seed-funding to acquisition, position your gaming company for success.

December 9, 2021 | 01:00 PM - 02:00 PM PT