Calculating a Calc Code 36 deduction

• 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?

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

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: 

1. Access Deduction and Benefit Master: Payroll > Payroll Setup Deduction and Benefit Master
2. Search for the deduction
3. Click Update
4. Click Folder next to Calc Code 
5. Note defined pays
6. Note the value in the Amt/Pct field
7. Click Cycles tab
8. Note Number of Payments
9. Select Accept
10. Click Exceptions
11. Note pay codes defined.

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

1. Access Employee Job/Salary: Payroll > Employee Maintenance > Employee Job/Salary
2. Search for employee
3. 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: 

1. Open the Payroll Start and Status program
2. Search for your Warrant and select Change
3. Click Earnings and Deductions
4. Search for the example employee number
5. Click the Pays tab
6. Sum amounts for any pays defined in the Deduction and Benefit Master Exceptions (Payroll Exceptions)
7. 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
8. Subtract the sum in Step 6 from the amount in Step 7
9. 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 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.