Rolling up time entry pay lines for payroll

Description of Issue

Would like pays rolled up / summarized in Earnings and Deductions in the payroll when move Time Entry batches. Would also like them rolled into one line on the Pay Checks/Advices.

Context
  • Enterprise ERP Munis version 2019.1 and higher
  • Payroll Processing
  • Time Entry
  • Payroll Control Settings
  • Pay Master
  • Payroll Start and Status
  • Earnings and Deductions
  • Print Payroll Checks
  • Print Payroll Advices
Cause


Resolution

First, update the Payroll Control Settings

  1. Access Payroll Control Setting (Payroll > Payroll Setup > Payroll Control Settings)
  2. Scroll down and double-click on Label  Rollup Time Entry Pays
  3. Click Update
  4. Enter Y for Value
  5. Click Accept

Update the Pay Master Paycheck/Cycles Tab for all pay types processed in Time Entry for the Pays to Rollup on the Checks/Advices:

  1. Access Pay Master (Payroll > Payroll Setup > Pay Master)
  2. Search for the pay type
  3. Click Update
  4. Click on the Paycheck/Cycles tab
  5. Select the Roll Up Pays option
  6. Click Accept
  7. Continue for each pay type that needs to be updated

Update the Pay Master TE Rollup option for rolling up the pays from Time Entry within Earnings and Deductions:

  1. Access Pay Master (Payroll > Payroll Setup > Pay Master)
  2. Search for the pay type
  3. Click Update.
  4. Select the applicable option in the the TE Rollup drop down.
  5. Click Accept. 
Additional Information

Please note the system will only rollup pay lines on checks/advices that are consecutive by date and Job Class.

The TE Rollup Setting:

Determines how the pay is rolled up in the Time Entry Rollup process: Always, Consecutive, Never, and Weekly by Start of Workday. Project ledger and general ledger accounts for rolled pays roll to a manual allocation and do not segregate the pays. The Pay rate segregates rolled pays, as applicable. Pays with dates prior to the current payroll are not rolled together with pay with dates within the current payroll, regardless if the TE Rollup list value is Always, Consecutive, or Weekly by Start of Workday.