Wednesday, June 18, 2014

Shortcut keys to find and filter data in AX 2012

You,me and everyone likes shortcut keys. MS Dynamics AX come with around 100 shortcut keys.

Seven of them designed to find and filter data. Today we are going to discuss The most important three in my opinion at least.

  1. ALT+F3                     Filter data by the current field value.
  2. CTRL+SHIFT+F3       Clear all filters.
  3. CTRL+UP ARROW    Move to the filter field of the column that the cursor is in.
In the following section we will use the "Main Account List" to demonstrate the previous shortcuts key.



  1. Go to General Ledger ----> Common ----> Main Account
  2. Select any value under the "Main account type" in my case i will chose Reporting.
  3. Press ALT+F3 The list will filter the data by the current field value.
  4. To remove All Filters press CTRL+SHIFT+F3 To Clear all filters.
  5. press CTRL + G To open the grid filter bar
  6. press CTRL+UP ARROW and the courser will move to the filter field of the column that the cursor is in.
Regards

To get new posts and updates, please follow the blog by clicking the Join this site Button in the top-right side under my personal information