Blended Overtime calculation is not including Longevity Pay Codes

Owned by Knowledge Assistant
Sept 15, 2022
2 min read



Description of Issue

Blended Rate OT code is not including Longevity, which is paid out once a year and the flat amount should be prorated within the blend. 



Context

  • Payroll

  • Payroll Start and Status

  • Earnings and Deductions

  • Pay Master

  • Assign Blended Rate Pay Types

  • Employee Job/Salary



Cause

  • The longevity pay code in Employee Job/Salary had an effective date prior to the base pay effective date.

  • The Pay in the Assign Blended Rate Pay Types screen did not have the correct Blend Amount option selected. 

    • The Assign Blended Rate Pay Types screen needs to be defined with either a Blend Amount of Projected Pay Amount (Pay) or Projected Pay Amount (Base)



Resolution

Update the Pay Master Assign Blended Rate Pay Types.

  1. Go to Pay Master (Payroll>Payroll Setup>Pay Master)

  2. Search for the blended OT pay code. Click Accept. 

  3. Click the Assign Pay Types button next to the Category Code. 

  4. Within the Assign Blended Rate Pay Types screen, click Update. 

  5. Under Blend Pays, locate the longevity pay code. 

  6. In the Amount column select either Projected Pay Amount (Pay) or Projected Pay Amount (Base). (See additional Information)

Two options:

  • The longevity pay code effective date will need to be on or after the base pay effective date. 

  1. Go to Employee Job/Salary (Payroll>Employee Maintenance>Employee Job/Salary)

  2. Search for the Employee and longevity pay code. Click Accept.

  3. Click Duplicate and define the effective date to match the base pay. 

  • A dummy pay code can also be created that mimics the longevity pay but does not have an end date. This can be added into Employee Job/Salary. 

    • If this option is selected, the pay code will need to be excluded from the Payroll Generate so it never generates into payroll and only exists for the blended rate calculation. 



Additional Information

  • The Blend Amount of Projected Pay Amount (Pay) will take the period amount on the pay divided by the base # of pays divided by the pay # of pays. 

  • The Blend Amount of Projected Pay Amount (Base) will just take the period amount on the pay divided by the base # of pays.