[BCB:5:Third-party support:ECB]
To use the formulas below the "Other" pay type must be based on calculation method "Other Units".
Rate per unit is on Setup, Employee, Deduction, "401K" in the amount field.
Calculation Method on Employee Deduction is Formula.
Select the formula created in Tools, Formulas in the Formula column.
In the example the Other pay ID is "WT".
Formula: COMB REG OT WT Units
IF(Pay Type(PR Time)= “REG” OR Pay Type(PR Time)= “OT”, Units(PR Time) + IF(Pay Type (PR Time) = "Other" AND Pay ID (PR Time) = "WT", units (PR Time)) * Amount (PR Employee Deduct)
If 401K is based on percentage of total pay plus other pay use the formula below:
Formula: COMB REG OT WT Units
IF(Pay Type(PR Time)= “REG” OR Pay Type(PR Time)= “OT”, Amount(PR Time) + IF(Pay Type (PR Time) = "Other" AND Pay ID (PR Time) = "WT", Amount (PR Time)) * Amount (PR Employee Deduct) / 100
DocLink: How do I set up a new Deduction in Payroll?
DocLink: How do I change a Deduction or Fringe amount?
|