SAP Knowledge Base Article - Public

2084601 - Currency - Conversion Not working when formula is in the calculation - Compensation

Symptom

  • Custom field currency conversion is supported in the product. Often custom fields are used with formulas and other hidden fields which may be part of the issue.
  • The value in a custom field is not working with currency conversion when other fields are correctly working with currency conversion

Environment

  • Compensation

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.
  • Import value 10000 to this field. As long as we define formula as:  lookup(…)*moneyFactor/10000, then the custom field will be converted correctly.

Keywords

KBA , sf compensation manage data , LOD-SF-CMP , Compensation Management , Problem

Product

SAP SuccessFactors HCM Core all versions