Override bonus plan

[SusanRoe]

We have employees who are kept at their existing Pay Band and Bonus plan after demotion (override/grandfather). While the pay band from the job may be 'A' with a bonus plan of 10%, they are kept at a 'B' representing 15%. This information from the job ('A') feeds into job information. We have created an override field to represent how they should be treated ('B'). Our bonus calculations are done based on actual earnings. So, normally we would use a custom formula for bonus calculation earnings*(incentive_pct/100). What need to do is If (Override_pct NE ' '), earnings*(override_pct/100), else earnings*(incentive_pct/100).

Any thoughts on how to accomplish this as the custom formula approach does not allow for the If/else?

[xavierlegarrec]

Hi nscorpsuro

Support of If-then rules in Basis calculation formula has been requested to Product but we don't know if and when they will build.

That being said in terms of workarounds : before 2nd half 2023 I can't think of any (even with contractual salary unless the target bonus % is stored in a paycomponent and we could leverage different pay component groups).

But with the new integration of MDF objects data to Employee History table coming in this release (recording #2) I believe it could be achieved.

If you have the earnings loaded in one MDF object for each employee then in a second MDF object you can build this logic with Lookup() function in Evaluate rules and then map the final outcome directly to a column of your employee history. And set your Basis calculation formula to simply be the ID of the emphistory column.

All the best

Xavier