Symptom
- When updating Payment Information for Mexico users, an error of "Please enter a valid CLABE number for MEX, which must contain 18 numeric digits appear".
- The Payment Information and Bank Account validation are not enabled from Company System Settings and no country specific validation configured.
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 - Employee Central
- SAP SuccessFactors - Employee Central Payment Information
Reproducing the Issue
1. Navigate to Employee's Payment Information portlet.
2. Click on Add/Edit.
3. Enter details for the fields including CLABE number.
4. Click on Save.
Error encountered: "Please enter a valid CLABE number for MEX, which must contain 18 numeric digits".
Cause
CLABE number has a deep validation in the system. System performs validation automatically regardless of settings.
Resolution
The system validates the CLABE number based on the following logic.
We will use this 18-digit combination as an example: 002073665883837938
- The last or 18th digit is taken out as the check digit. For our example, it is 8.
- All the numbers from 1 to 17 are grouped by 3-digit and are multiplied by 3,7,1.
- If the number is (002)(073)(665)(883)(837)(93) then all the values in the group are multiplied by (3,7,1)
- (0 * 3, 0 * 7, 2 * 1) (0 * 3, 7 * 7, 3* 1) (6 * 3, 6 * 7, 5 * 1) (8 * 3, 8 * 7, 3 * 1) (8 * 3,3 * 7, 7 * 1) (9* 3, 3 * 7)
- Ans = (0,0,2)(0,49,3)(18,42,5)(24,56,3)(24,21,7)(27,21)
- Perform MOD 10 on all of the numbers in the result above.
- Ans after mod 10 ->(0,0,2)(0,9,3)(8,2,5)(4,6,3)(4,1,7)(7,1)
- Sum all the values.
- 0+0+2+0+9+3+8+2+5+4+6+3+4+1+7+7+1
- Sum = 62
- Perform MOD 10 on the sum
- 62 % 10 mod_sum = 2
- Perform the following calculation (10-mod_sum)%10
- (10-2)%10 = 8
ANSWER: The result 8 should match the check digit value (18th digit at the beginning).
If the value matches, the CLABE is valid. Else, error message will be displayed.
You may also download the attached CLABE Calculator Excel File to automate the calculation. You will just need to enter the 18-digit value.
See Also
ECT-96726
Keywords
Payment Information, Bank, Validation, Calculation, Check digit, Clabe. , KBA , LOD-SF-EC-PAY , Payment Information (Bank Information) , How To