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
Costco Travel Webinar
One of the world’s top retailers reveals their cloud upgrade process.

May 19, 2022 | 11:00 AM - 11:30 AM PT
Overview of Sage Intacct R2 Release Webinar
Learn the newest features and enhancements in Sage Intacct from the 2022 Release 2.

May 18, 2022 | 01:00 PM - 02:00 PM PT
Foundation Cuts Manual Data Entry, Empowers Staff With Robotic Process Automation
Case Study
RPA tech enables lasting growth, boosts savings and frees up staff to redirect their time to meaningful strategies.

May 18, 2022