Phone
+62-877-8655-5055
+62 (21) 580-6055

Email
sales-enquiry@sterling-team.com

Address
Sampoerna Strategic Square
South Tower 18th
Jl Jend. Sudirman kav 45-46
Jakarta 12930 - Indonesia

Use Filter Table for Simplify Your Data

When you do your daily job with SAP Business One, of course that will be used a lot of data. Therefore, we need to find ways to organize this huge amount of data. In the business world, for user, a table is a popular and very familiar option to make it easier to see data more easily and efficiently.

However, sometimes, just displaying data in the form of a table is not enough, an additional feature is still needed to make it easier for users to process data according to their own needs. SAP Business One itself gives you the FILTER feature tosimplify the display of data in the table, thus, not all data will be appeared, but that will be showed only based on your choices that you choose to see.

How to do that?

Please click on filter icon, then a new window will be open with title ‘Filter Table’:

SAP Business One Tips - STEM SAP Gold Partner Indonesia - Using Filter Method on SAP B1

Filter Icon on Menu Bar

SAP Business One Tips - STEM SAP Gold Partner Indonesia - Using Filter Method on SAP B1

Here you can add new rules for every selected and relevant fields, and click FILTER button to activate your filter. There will be a various rules available on it:

Rules Means if its on query
Equal =
Not Equal !=
In Range IN
Out of Range NOT IN
Greater Than >
Greater or Equal >=
Smaller Than <
Smaller or Equal <=
Is Empty IS NULL
Is Not Empty IS NOT NULL

So, after that, all of data will be filtered based on your own preferences.

SAP Business One Tips - STEM SAP Gold Partner Indonesia - Using Filter Method on SAP B1

, , ,