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
- Define Number Formats for Money Values by Currency (no rate type defined).
- Create a custom column in design worksheet.
- Select the money format to be "default money format".
- 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