Filtering Data in SAP
Business One 
Use
Use the procedure below to filter data in SAPBusiness One.
Procedure
1. In SAP Business One, choose a document or report with data you want to filter.
2.
On
the toolbar, choose 
Filter
Table…
The Filter Table window appears.
You can also access the window by choosing Data ® Filter Table… Or, by clicking the right mouse button and choosing Filter Table…
3. Define the filter as required: select the appropriate rules and values.
4. Choose Filter to confirm filter definitions.
The selected window appears with the required filtered data. The filtered fields appear with the Filter icon.
5. Choose OK to close the Filter Table.
Removing Filters from the Form
1. Open a document or report which you have previously filtered.
2.
On the toolbar, choose Filter
Table…
The filter is removed from the window.
Clearing Filters in the Filter Table
1. Open a document or report which you want to or have already filtered.
2.
On
the toolbar, choose Filter
Table…
3. To clear the filter, choose Clear and then OK.
The filter is removed.
See also: