In this article
This command changes the sorting of rows permanently.
It is therefore advisable to be very careful before sorting, especially when in the Accounts Table, as it may upset the structure of the chart of accounts.
If you only wish to sort rows temporarily use:
- Temporary Filter and Sort rows.
- Extract and Sort rows that copies the data into a temporary table .
Sort Rows Dialog
This function is activated via the Data > Sort rows menu.
The rows of the table can be sorted according to the contents of the columns. Up to three sorting can be set.
Sort by
Select the type of order you need from the list that appears.
Then by
Allows you to define an additional type of sorting than the main one.
Ascending
The rows are sorted in ascending order, taking into account the type of sorting chosen (date, doc ...).
Descending
The rows are sorted in descending order, taking into account the type of sorting chosen (date, doc ...)
Number
Enable this option if the column chosen as the search condition contains only numbers.
Clear all
The button allows you to delete the settings chosen for sorting the data in the various lists.
Selected rows only
This option is active only when rows have been previously selected and allows the sorting of the selected rows
Customization Section
Through this section, you can customize and save various sorting settings for the rows.
You can choose to sort by Amount, Description, or other criteria, and save the sort settings with different names.
When needed, you can recall the sort settings by selecting the name of the desired sort.
Name
The name of your customization (e.g., Sort by Description, Sort by Amount, etc.).
Description
Enter a description to reference the settings (e.g., "sorting type 1, sorting type 2", etc.).
Set as Default
With the "Set as Default" button, you can set a sort as the default.
Options
For more information, refer to the Customization page.