Description of Issue

My calc code 36 deduction does not look to be calculating correctly. How can I prove out the calculation?
Question how deduction cc36 calcs
How does Calc Code 36 work?

Context

Enterprise ERP Payroll
Payroll Processing
Deduction and Benefit Master
Employee Job/Salary

Cause

Resolution

Calc Code 36 deductions are a (sum of Reference Salary amounts from Job/Salary divided by # of payments) - (sum of amounts in the Warrant for pays defined in Payroll Exceptions) * Percent.

Use the details below to prove the calculation out for a specific employee and Warrant.

Collect details from the Calc Code 36 deduction record:

Access Deduction and Benefit Master: Payroll > Payroll Setup Deduction and Benefit Master
Search for the deduction
Click Update
Click Folder next to Calc Code
Note defined pays
Note the value in the Amt/Pct field
Click Cycles tab
Note Number of Payments
Select Accept
Click Exceptions
Note pay codes defined.

Sum Reference Salary for defined pays in Employee Job/Salary:

Access Employee Job/Salary: Payroll > Employee Maintenance > Employee Job/Salary
Search for employee
Sum all Reference Salary amounts, for pays defined in the Deduction and Benefit Master Calc Code 36 folder

Review the Payroll Warrant details and calculate:

Open the Payroll Start and Status program
Search for your Warrant and select Change
Click Earnings and Deductions
Search for the example employee number
Click the Pays tab
Sum amounts for any pays defined in the Deduction and Benefit Master Exceptions (Payroll Exceptions)
Divide the Employee Job/Salary Reference Salary sum by the Number of Payments defined on the Cycles tab of the Deduction and Benefit Master record
Subtract the sum in Step 6 from the amount in Step 7
Apply the rate defined in the Deduction and Benefit Master Amt/Pct field to the result from Step 8. This should match the withholding amounts you see reflected for the deduction on the Withholdings tab

Additional Information

Additional details: Calc Code 36 KB doc.
Note - If an employee is being paid out of an accrual type pay code with no base pay (vacation, sick, etc.) those pays should be included in the Defined Pays folder.

Browser not supported