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
Sage Transform VIP Experience
Live Event
VIP luncheon for top finance executives attending Sage Intacct 2022.

October 12, 2022 | 09:30 AM - 10:45 AM PT
Women in Life Sciences: Women’s Health & Wellness
Spill the Tea With Delphine O’Rourke on the State of Women’s Health

October 11, 2022 | 02:00 PM - 03:30 PM PT
ASC 842: Lessons Learned From Early Adopters
Get the scoop from early adopters who have implemented ASC 842.

October 6, 2022 | 09:00 AM - 10:00 AM PT