SAP Knowledge Base Article - Public

2823046 - Custom money fields not following custom number format

Symptom

  • Custom money fields with/without formula are not following the custom number format based on currency.
  • Custom money fields follow the default number format, whereas standard fields follow the custom number format based on currency

"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
  • Compensation

Reproducing the Issue

  1. Define Number Formats for Money Values by Currency (no rate type defined).
  2. Create a custom column in design worksheet.
  3. Select the money format to be "default money format".
  4. Launch worksheets to see the custom column follow default money format instead of the custom money format created.

Cause

Even though the custom number format is defined for money fields, the money format selected for the custom field is "default money format" which will overwrite the custom money format.

Resolution

The money format on the design worksheet for the custom money field should be "user rate type" even though rate type specific money format is not defined. We don't have an option to select this money format for the standard fields and hence, they follow the custom money format without specifying explicitly.

Note: custom format based on currency is not applicable to amount fields.

Keywords

SF, successfactors, defMoneyFormat, country specific number format, CMP-20149, number format rule not applied on custom money field , KBA , LOD-SF-CMP-FRM , Forms & Templates , Problem

Product

SAP SuccessFactors Compensation all versions ; SAP SuccessFactors HCM Core all versions