A3.174 : How to preview report filtered by selected fields and shows only non-zero amount?
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
Answer :
1) Go to Reports > Payroll report. Then select Payroll Summary > click Design.
2) Select DetailReport (Detail Report) for Properties
3) Click on ... at Filter String option.
4) Remove all unwanted fields. Only remain the fields we want to show.
5) Remain the Zakat field. Then click Advanced Mode
6) Make sure the detail show as Zakat <> 0.0. Then only click OK
7) Save as a new report.
8) Preview report, it should only show the employee that has Zakat deduction.
--Source from AutoCount Wiki --
Related Articles
A5.33 : Profit & Loss by document – Service Product and Non-Inventory Product having zero Local Total Cost
Question: When view profit and loss by document, why does service product and non-inventory product show zero local total cost? Possible Reason: You did not key in the cost in Invoice. Solution: 1) Edit your Invoice, click on Column Chooser icon and ...A3.41 : Payroll : My employee has high salary, why Process Payroll shows zero PCB amount?
Question : My employee has high salary, why Process Payroll shows zero PCB amount? Answer : Your employee maintenance setting may be not complete. 1) Go to Payroll > Employee Maintenance. 2) Edit the employee. 3) Go to Statutory Requirement > Income ...A3.220 : Management Report : Preview report error – Empty Report
Question : I already run payroll for January but when I try to preview payslip from Management Report, system prompted message “Empty Report”. Possible Reason : The January payroll has not been Committed. Solution : Before a payroll process is ...A3.222 : Report : Preview report error – nothing prompt/appear
Question : I want to preview payroll report but after click on Preview button nothing appear. Possible Reason : Your browser setting has blocked pop-ups and redirects from Cloud Payroll. Solution : 1) On your browser, click on the pop-ups icon. 2) ...A3.223 : Report : Why when I preview past month payroll summary report not tally with process payroll?
Question : Why when I preview past month payroll summary report not tally with process payroll? Possible Reason : There are resigned employee and user did not include them when preview report. Solution : 1) In the Payroll Summary Report page, tick on ...