Filters refine your search in SAP Business One. For example, when a report yields too many hits, you can narrow the search to a specific customer code or due date range.
Use the procedure below to filter data in SAP Business One.
In SAP Business One, select a document or report containing data you want to filter.
In the toolbar, choose (Filter Table...).
The Filter Table window appears.
Define the filter as required, selecting the appropriate rules and values.
To confirm the filter definitions, choose Filter .
The selected window appears with the required filtered data. The filtered fields appear with the (Filter) icon.
To close the Filter Table window, choose OK.
To see an unfiltered view of the document or report, choose (Filter Table...) in the toolbar.
Note
By default, SAP Business One saves the last filter selections for each document or report. To delete existing filter selections, you must choose Clear and then OK in the Filter Table window.