Sorting Invoices in Service Automation
- Anastasia Medovkina
Owned by Anastasia Medovkina
Using the Sorting tool, you can arrange invoices by individual parameters or by selecting several custom parameters.
Sorting Invoices by Individual Parameters
You can sort invoices by selecting one of the following parameters:
- Date
- Invoice #
- Purchase Order #
- Batch ID
- Trade
- Location ID
- Provider
- Status
- Amount
You can sort invoices by selecting several parameters at once with the help of the Custom Sort... tool.
⦿ How to Sort Invoices by Individual Parameters
- Select one of the sorting parameters from the drop-down menu.
In this example, the Invoices List is arranged by trade and displayed in alphabetical order. - (Optional) To reverse the order, click the toggle switch icon.
Sorting Invoices by Custom Sorting Parameters
The Custom Sort feature allows you to sort data by up to three parameters, applying them sequentially across multiple levels for more refined control.
⦿ How to Sort Invoices by Custom Parameters
- On the Sorting tool, select Custom Sort..
- In the window that appears, select the first sorting parameter to arrange invoices by, for example, by Amount.
- Select the second parameter in the Then By dropdown. For example, by Date.
- Select the third parameter in the last Then By dropdown. For example, by Provider.
- Click Apply.
Thus, the Invoices List is arranged in the following order:- By invoice amount, from highest to lowest
- By date, from oldest to the recent
By providers in alphabetical order
By default, the order is descending , should you have switched the order in step 2, the sorting order will be ascending.
Ascending order examples:
- Small to Large (Amount)
- A to Z (Provider Name)
- Newest to Oldest (Date)
Descending order examples:
- Large to Small (Amount)
- Z to A (Provider Name)
- Oldest to Newest (Date)
The sorting will be reset after you update the page or when you change the sorting parameter.