401K Matching Fringes: Formula Example 1 (Payroll Help Topics)

Solution Properties

Solution ID:

224924750069271

Last Modified Date:

Mon Jul 05 16:04:22 UTC 2021

Taxonomy Path:

Category//Transactions//Calculations

Author:

[email protected]

401K Matching Fringes: Formula Example 1 (Payroll Help Topics)

Description

Cause

401K Match Formula 1 in the Help Topics is missing a parenthesis. This issue has been reported, and will be addressed in a future update.

Resolution

Correct formula should be:

MIN((LOOKUP(Amount[PR Check Deduct], Employee[PR Check], Period End Date[PR Check], Check Sequence[PR Check], "401K") * .5), Gross Pay[PR Check] * 0.06)

Steps to duplicate