The Average Salary by Department SmartList Builder template is built to calculate the average salary for each department setup in the Microsoft Dynamics GP Payroll module. It uses the Pay Rate Amount from the Payroll Pay Code Master and is summarized by Department. This is only for Pay Type of Salary.
SmartList ID: UPR_AVG_SAL_DEP
SmartList Name: Average Salary by Department
Tables Involved:
- Payroll Pay Code Master
- Payroll Master
- Payroll Department Setup
Screen shots of Setup in SmartList Builder, Excel Report Builder, and Navigation List Builder.
Note:
These templates are designed to be a starting place for your reporting needs. While we try to make them as accurate as possible, we always recommend you check them with your data as we don’t guarantee their results. Differences in how data is entered and used in Microsoft Dynamics GP can produce different results with these templates.
