Correct the formula for the 401K Fringe.
Change the formula to calculate the 401K deduction within the 401K match formula rather than look up the 401K deduction from the check record.
When the 401K deduction calculates within the 401K match formula, then the 401K match fringe is included in the certified fringe hourly rate.
This formula should be created and inserted into the 401K Matching Fringe formula. It will replace the part of the original formula that looks to the amount of the deduction on the PR Check Deduct record. This will make the 401K matching fringe amount calculate the 401K deduction amount within the fringe calculation. This formula will calculate correctly if the default is gross pay. This will not decrease the Cash Fringe Pay if the employee elects a flat amount to be deducted.
401K Deduct Amt
IF(LOOKUP(Calc Method (PR Employee Deduct), Employee (PR Check),"401K") = "Default", Gross Pay (PR Check) * LOOKUP(Amount (PR Employee Deduct), Employee (PR Check), "401K") / 100)
You must create a formula to meet your company's specific setup and needs. Refer to the link below for steps and considerations on 401K matching fringe formulas.
DocLink: How do I set up a 401K matching fringe formula?
|