Cloud Payroll -How to preview report filtered by selected fields and shows only non-zero amount?

From AutoCount Resource Center

Question : How to preview report filtered by selected fields and shows only non-zero amount?


Example: Preview payroll summary report only for employees that have Zakat deduction

FilterNonZeroAmount 01.png

Answer :

1) Go to Reports > Payroll report. Then select Payroll Summary > click Design.


FilterNonZeroAmount 02.png


2) Select DetailReport (Detail Report) for Properties


FilterNonZeroAmount 03.png


3) Click on ... at Filter String option.


FilterNonZeroAmount 04.png


4) Remove all unwanted fields. Only remain the fields we want to show.


FilterNonZeroAmount 05.png


5) Remain the Zakat field. Then click Advanced Mode


FilterNonZeroAmount 06.png


6) Make sure the detail show as Zakat <> 0.0. Then only click OK


FilterNonZeroAmount 07.png

7) Save as a new report.


FilterNonZeroAmount 08.png


8) Preview report, it should only show the employee that has Zakat deduction.


FilterNonZeroAmount 09.png



Prepared by Azirah 220608, P220627



Go to menu

IconAcc20.PNG AutoCount Accounting 2.0 & 2.1


IconAcc188.PNG AutoCount Accounting 1.8 / 1.9
Wiki-Payroll.png AutoCount Payroll
Wiki-POS.PNG AutoCount POS


Wiki-AOTG.PNG AutoCount On The Go
Wiki-Accounting-Plugin.png AutoCount Accounting Plug-In Documentations