cancel
Showing results for 
Search instead for 
Did you mean: 

SuccessFactors Variable Pay Aggregated Payout Issue

0 Kudos
318

Hello All,

I have a scenario where employees are having multiple assignments with different currencies. At assignment level, I am calculating Payout using formulas.

For Ex:- Employee ABC is having two assignments. One is in USD currency which is history and Second one is JPY which is top of stack (Latest assignment).

Consider USD payout is 15,107 and JPY Payout is 123,289. As these two Payouts are in different currencies, system should convert history USD payout 15,107 to JPY 2255399 and Payout aggregate value should display in JPY as its top of stack currency. (Which should be USD 15,107 converted to JPY 2255399 added to top of stack payout JPY 123,289)

However System is not converting History USD payout 15,107 to JPY. Its adding USD with JPY and showing aggregated value in JPY as 15707+123289= 138996 and displaying as Payout in form instead of JPY 2255399+123289=2378688 as Payout

payout-issue.jpg

Please suggest if we have any option to overcome this situation.

Thanks In advance.

Balakrishna Adusumalli

Accepted Solutions (0)

Answers (1)

Answers (1)

xavierlegarrec
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi balakrishna.sfusa

In standard configuration the system does the conversion itself to the currency of the last assignment but based on the screenshot you shared here you have a custom configuration where the payouts are calculated at the assignment level in custom fields so it needs to be built in the assignment level with additional configuration.

Providing that the currency of the last assignment is the same than the currency of the user as of the Plan Setup > EC effective date (in most configurations and in leading practices EC Effective Date = Program End Date in which case they are by default in sync), then you need to build the following:

  • Create a lookup table from USD to local currency with all possible values. (USD to GBP, USD to JPY, USD to EUR...)
  • In a new ALCF column switch every payout to one currency thanks to the lookup currency rates you just created.
  • Aggregate all converted payouts (they are now all in the same currency) into an amount custom column at summary level
  • In a new column at summary level turn the USD payout into the local currency of the last assignment (stored in standard local currency code).

All the best

Xavier