Tuesday, July 9, 2019
Customize a Report to Display Total Amounts Per Employee, Department and Payroll Item
Standard Report for Payroll commonly display items by row. To achieve different format, we may create a report from scratch by using Matrix Report.
Steps to create a matrix report:
A. Create Transaction Column Field
--Customization > Lists, Records, & Fields > Transaction Line Fields > New
--Enter name of column field next to Label field
--Type = List/Record
--List/Record = Employee
--Store Value = True
B. Create New Report
--Reports > New Report > Transactions
--Enter name of report next to Report Title
1. Select the field you want to report on.
Metric = Amount
2. Select the format of the report.
Click the radio button next to Matrix
3. Select how you want to subtotal the report.
a. Component = Transactions
b. Field = search for the transaction column field created in letter A above
4. Data Column = Payroll Item
--Click More Customization
--Click Edit Columns
--Click Transactions Folder
--Click Department Folder > click Name
--Click Entity Folder > Click Name (2nd field)
--Click Payroll Item Folder > Click Type (1st)
--On the Report Preview pane, move the columns to the left following this format:
Custom Transaction Field
Payroll Item Type
--Go to Payroll Item Type column and click Group With Previous Column checkbox
--Preview or Save