This tutorial explains how to filter all customers who spent more than $10,000 this year.
To open Customers, go to Navigator > Maintain > Accounts Receivable > Customers.
Click the Filter & Sort button by the Select Customer field.
In the Field Name drop-down, select the field SalesYearToDateBs. Note: The 'Bs' at the end of the field name signifies that this is in the Base Currency.
In the Op field, select > (Greater than).
In the Criteria field, type 10000.
Click Save (F9).
The Filter & Sort button is displayed as , showing a filter is applied.
Customers listed in the Select Customer drop-down are now filtered to only those who meet the filter criteria.