SAP Knowledge Base Article - Public

2084601 - Currency Conversion not working when formula is in the calculation

Symptom

  • The value in a custom field is not working with currency conversion when other fields are correctly working with currency conversion.
  • Certain lookup fields value change to local currency even though the view is in functional currency when a value is entered in an editable field.

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."

Environment

  • SAP SuccessFactors HCM Core
  • Talent Management 
  • Variable Pay

Reproducing the Issue

  1. Custom field A is defined with lookup value formula.
  2. Custom field B is editable field on the worksheet.
  3. Worksheet is launched and when value is entered in field B, the value in field A changes to the local currency value even though the view is in functional currency.

Cause

  • A formula exists in the conversion table
  • Or one of the fields in the formula is set to TYPE = AMOUNT

Resolution

  1. Be sure the fields being used are not set to type = AMOUNT. This is not supported in currency conversion.
  2. There maybe trouble with the currency conversion when there is a formula in the conversion table and also look up table is used in the formula. Because the number returned by lookup table is not an amount value, currency conversion will not apply.

There is a way to work around this in formula definition by using a hidden constant money Field called moneyFactor (can be imported from UDF/EC or set to a constant value 10000). As long as we define formula as:

toNumber(lookup(…)*moneyFactor/10000), then the custom field will be converted correctly.

 

Keywords

sf, successfactors, some fields in local currency even though view in functional currency, VRP-8038 , KBA , sf compensation manage data , LOD-SF-VRP , Variable Pay Programs , Problem

Product

SAP SuccessFactors Compensation all versions ; SAP SuccessFactors HCM all versions