We are surrounded by huge amounts of data and often look for the best way to organise it. When it comes to business, tables are a popular structure as they allow us to efficiently consume and process the data. However, many times this is not enough and additional fine-tuning is needed. For such cases, SAP Business One enables you to filter the data presented in tables:

Clicking the filter icon opens a filter window in the context of the presented table:

Here you can assign the required rules to the relevant fields, and choose the “Filter” button to apply your filters. The filtered table is refreshed accordingly, and if needed you can fine tune your filter until the desired data is displayed in the table. The filter functionality is available for reports and queries in which the are results displayed in flat tables.

Available in SAP Business One, version for SAP HANA and SAP Business One.

We hope that you find this tip useful! For more information on Business One you can visit our webpage or get in touch.

Source: Ari Schapira | SAP Business One – The Tip of the Week