Sort records
Important
This content is archived and is not being updated. For the latest documentation, see Microsoft Dynamics 365 product documentation. For the latest release plans, see Dynamics 365 and Microsoft Power Platform release plans.
Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012
In forms where the records are listed in a grid, you can sort data in ascending order (A through Z) or descending order (Z through A).
Sort by one field
You can sort data by using a single criterion. For example, you can sort the items in the Product table according to the product type instead of the product name, which is the default sorting setting.
Select any field in the column to sort by.
Right-click on the column to sort, and then select either Sort ascending or Sort descending.
Tip
You can also sort data by clicking the column header in the table. Click the header again to reverse the sort order.
Sort by more than one field
You can use Advanced sorting to sort by more than one field. For example, you can sort the customers in the Customers table first by Customer group and then by Name.
Click File > Edit > Filter > Advanced Filter/Sort.
Click the Sorting tab.
Press CTRL+N to add a new line.
In the Table column, select the table that contains the field to sort.
In the Field column, select a sorting field.
In the Search direction field, select Ascending or Descending.
Repeat steps 3 through 7 to add more sorting criteria.
Select a sorting criteria row and then click the Up or Down buttons to change the sort order.