Troubleshooting: Save A/P Payment error - Cannot set column ‘DealWith’. The value violates the MaxLength limit of this column

From AutoCount Resource Center

Question: When I try to save A/P Payment, system prompted error “Cannot set column ‘DealWith’. The value violates the MaxLength limit of this column.”?

Version: 1.9

Dealwith maxlength1.png


Possible Reason:

This is a known bug where A/P Payment character limit (80 character) is less than Creditor Company Name (100 character). This bug is fixed in version 1.9.010.43.


Solution (1):

Look into Creditor Maintenance, examine the creditor name, shorten creditor name if it is too long, and remove unnecessary empty spacing.

Dealwith maxlength2.png


Solution (2):

Update to Version 1.9.010.43 or later, and you should be able to Save the A/P Payment.


By: Rotcana 220615, Lay Swan 220627, P220628


Go to menu

IconAcc20.PNG AutoCount Accounting 2.0 & 2.1


IconAcc188.PNG AutoCount Accounting 1.8 / 1.9
Wiki-Payroll.png AutoCount Payroll
Wiki-POS.PNG AutoCount POS


Wiki-AOTG.PNG AutoCount On The Go
Wiki-Accounting-Plugin.png AutoCount Accounting Plug-In Documentations