Error: ACCOUNT value length exceed the column field length :11. value = 0123456789012
Symptoms:
Error prompted "ACCOUNT value length exceed the column field length :11. value = 0123456789012" when trying to generate a bank disk file in the Payroll module.
Possible cause(s):
There is at least one employee who has invalid length of bank account number under Payroll > Employee Pay > Payee Data > Bank Detail.
Suggested workaround/ solution(s):
1. Check the staff's account number again at Payroll > Employee Pay > Payee Data > Bank Detail, and ensure it is correct.
2. The Admin may generate the report "Employee Payroll Setting (Managed Pay Group)" under Payroll Intelligence if he/she is not sure which particular bank account is causing the issue. This report will show all the staffs' bank account number and the Admin will be able to identify the staff based on the bank account number.