A3.158 : Reports : How to show main department in payroll summary report?

A3.158 : Reports : How to show main department in payroll summary report?

Question : How to show main department in payroll summary report?

Let say your department consists of main and sub departments. In payroll summary report, you want to show only the main department, and there are two sub departments under the main (Account) department (as in Figure 1)


MainDeptOnly1.png

Figure 1


Answer :


1. Go to Reports > Management Report > Payroll Summary > Design (as in Figure 2 ).

MainDeptOnly2.png

Figure 2


2) Click on Detail 1 > Properties > Change to Group Header 1 (as in Figure 3 ).

MainDeptOnly3.png

Figure 3


3) Click Group Field > Group By > Change Department to Department First Level (as in Figure 4 ).

MainDeptOnly4.png

Figure 4


4) Save as New Report - Payroll Summary by Main Department (as in Figure 5 ).


MainDeptOnly5.png

Figure 5


5) Now you can preview payroll summary and select Payroll Summary by Main Department (as in Figure 6 ).


MainDeptOnly6.png

Figure 6


--Source from AutoCount Wiki --