Merit calculation to be to be based on Custom Current Pay Rate field

[swagatikapanda]

Hi Experts,

We are using Rate Planning where employees are in hourly, weekly, semi-monthly frequencies. My requirement is to calculate merit based on a custom field (which is current pay rate+bring to minimum amount). I have used a custom field instead of curSalary for current pay because for hourly employees, frequencies are made 0 in EC leading to Annualized Salary 0.

As per KBA 3310736 - Merit percentage automatically updated after change in worksheet field - Compensation - SA..., I updated the xml with the field-id of the custom current pay (current pay rate+bring to minimum amount), but its not working. Merit amount is still using Current pay rate only.

Please help to check what is going wrong in my config.

@xavierlegarrec 

Thanks,

Swagatika

[xavierlegarrec]

Hi @swagatikapanda 

No you can only use a custom field with ID = meritTarget (and you also have to switch a tag at the bottom of the XML to “Target”) and import the data from EC for it or import it through UDF if no EC. That field cannot be controlled by a formula so no lookup table possible. Configuration examples here.

Another option is to use compounding which allows us to base the merit increase off of merit + another recommendation column for example (extra). 

All the best,

Xavier

[andoniainaMestrallet]

Hello @xavierlegarrec ,

we implemented this solution for a customer recently and it works fine. Thanks you!

However, this creates an inconsistency of data in case we do use the standard fields TotalRaise and TotalIncrease. These fields have the correct total amount but the % is false as it keeps having the basis=curSalary.

Have you ever experience this? Could you tell if this is expected behavior or if these is any workaround?

Thanks you for any inshights!

SAP SuccessFactors Compensation 

[xavierlegarrec]

Hi @swagatikapanda 

There is probably nothing wrong with your config, there is a product bug with Hourly employees data not coming correctly from EC into Compensation and Variable Pay that our engineers are working on fixing. Current patch date is 24th in preview and Dec 30 in production.

There are two other threads on this on the community :

https://community.sap.com/t5/sap-successfactors-compensation-user-group/calculating-salary-within-va...

https://community.sap.com/t5/human-capital-management-q-a/issue-with-employee-history-salary-field-f...

All the best

Xavier

[swagatikapanda]

Hi @xavierlegarrec

Thanks for update on the Annualized salary issue for hourly.

But my case is slightly different. I am not using the standard curSalary field as base for calculating merit, extra and lumpsum, instead using custom Current Pay Rate (calculated as Current Pay Rate+promotion). So basically merit amount should be custom Current Pay Rate*merit%. 

But when I am trying to update the xml, getting error:

Attribute "fieldId" with value "customSalAfterMinAdjust" must have a value from the list "curSalary promotion merit extra extra2 ".

Also, please can you help me understand what is <merit-calc basedOn="CurrentSalary"></merit-calc> mean, I don’t think any field name called CurrentSalary. I also tried replacing the field name of the custom rate in place of CurrentSalary, but got similar error.

Attribute "basedOn" with value "Current Pay Rate After Bring to Min" must have a value from the list "CurrentSalary Target "

So my question is it possible to use a custom field as base for multiplying merit/extra/lumpsum %?

Here is the full xml (lumpsum2 and extra2 are not in use, so has the standard config)

          <lumpsum-calc basedOn="Current Pay Rate After Bring to Min"></lumpsum-calc>

          <lumpsum2-calc basedOn="CurrentSalary"></lumpsum2-calc>

          <merit-calc basedOn="Current Pay Rate After Bring to Min"></merit-calc>

          <comp-compounding useFor="merit">

           <percentage-calc-base-includes fieldId=" customSalAfterMinAdjust "/>

          </comp-compounding>

          <comp-compounding useFor="extra">

            <percentage-calc-base-includes fieldId=" customSalAfterMinAdjust "/>

          </comp-compounding>

          <comp-compounding useFor="extra2">

            <percentage-calc-base-includes fieldId="promotion"/>

            <percentage-calc-base-includes fieldId="curSalary"/>

          </comp-compounding>

Thanks,

Swagatika