cancel
Showing results for 
Search instead for 
Did you mean: 

Pay Target Rules

cdelve
Discoverer
0 Kudos

Is it possible to create a business rule that adds together a number of different pay target pay components to default a pay component held in basic pay?

Currently I have 1 target pay component for FTE Annual Salary that automatically populates the basic pay pay component with the prorated monthly salary. I now want to add a number of different pay components held within the pay target before it creates the monthly salary. For example:

  • FTE Annual Salary £20000
  • Standby Allowance 10% (£2000)
  • Flex Allowance 5% (£1000)

Total Annual Amount £23000

I then want the £23000 to be prorated based on FTE and the monthly amount created in the Basic Pay

Accepted Solutions (0)

Answers (2)

Answers (2)

nlgro023
Active Contributor
0 Kudos

Number should be your var, treat as nul should be 0 (so you've sort of swapped it around) by what I can see. The intention of that function is to look first at the pay component value (of which you've now said is always 0) and if it is non-existent it should write a 0. That is used to ensure that if you don't have it, the formula (hopefully) doesn't break. Else you'd need a whole lot of if then else statements to validate all the combinations of those 3 components available to calculate.

cdelve
Discoverer
0 Kudos

Hi Jasper,

I have switched this round as per your suggestion and it is making the salary "0", am I missing something?

I want the total of all the Add Multiple pay components to be used to calculate the Salary and post this to pay component 0100.

Thank you in advance

nlgro023
Active Contributor
0 Kudos

I'm not sure if that's the wrong picture, but it looks like nothing changed apart from this funky delete.
You may want to run a rule trace too, on this rule. Then you can see in the log why it's not triggering as I for instance cannot see what you put in your var_'s. It could for instance be that your create should be a set or that your var_'s don't actually provide a value too.

nlgro023
Active Contributor
0 Kudos

Can be done in 3 ways. The traditional way is that you combine these things in a pay component group, so that the pay component group displays it on the compensation portlet (you can manage the visibility via RBP). The downside is that you can't really use that for other purposes (i.e. reporting / logic).

You can have 1 pay component that combines these values. In the Set part of the business rule (or in a variable) you can set the desired pay component with
Add Multiple
Treat as Null of Amount where paycomponent = FTE Annual Salary
and putting 0 in the treat as number field
Treat as Null of Amount where paycomponent = Standby Allowance
and putting 0 in the treat as number field
(note for this 1 I recommend making a variable that first calculates the #)
Treat as Null of Amount where paycomponent = Flex Allowance
and putting 0 in the treat as number field
(note for this 1 I recommend making a variable that first calculates the #)

You can have 1 field in compensation info that combines these values. In the Set part of the business rule (or in a variable) you can set the desired field with
Add Multiple
Treat as Null of Amount where paycomponent = FTE Annual Salary
and putting 0 in the treat as number field
Treat as Null of Amount where paycomponent = Standby Allowance
and putting 0 in the treat as number field
(note for this 1 I recommend making a variable that first calculates the #)
Treat as Null of Amount where paycomponent = Flex Allowance
and putting 0 in the treat as number field
(note for this 1 I recommend making a variable that first calculates the #)

cdelve
Discoverer
0 Kudos

Hi Jasper

Thank you for your reply.

I have tried the second option but the pay component that I am trying to post a combined value to is being set to 0, how can i make this look at the amount/calculated amount? Below is how my rule currently looks: