Pos3/5/FNB: Sync error Debtor Address Maxlength limit
Question :
During sync, there is an error regarding max length, what should I do?
Cannot set column 'Address1'. The value violates the MaxLength limit of this column.
or
Cannot set column 'Address2'. The value violates the MaxLength limit of this column.
or
Cannot set column 'Address3'. The value violates the MaxLength limit of this column.
or
Cannot set column 'Address4'. The value violates the MaxLength limit of this column.
Possible Reason :
When import from excel, address data contains special characters (Enter, Tab and others).
Solution :
1.Go to AutoCount Management Studio > Tools > SQL Query > Yes > enter the checking query > Execute.
Checking Query:
(Debtor)
select * from Debtor where address1 like '%'+char(13)+'%' or address1 like '%'+char(10)+'%'
select * from Debtor where address2 like '%'+char(13)+'%' or address2 like '%'+char(10)+'%'
select * from Debtor where address3 like '%'+char(13)+'%' or address3 like '%'+char(10)+'%'
select * from Debtor where address4 like '%'+char(13)+'%' or address4 like '%'+char(10)+'%'
(Member)
select * from Member where address1 like '%'+char(13)+'%' or address1 like '%'+char(10)+'%'
select * from Member where address2 like '%'+char(13)+'%' or address2 like '%'+char(10)+'%'
select * from Member where address3 like '%'+char(13)+'%' or address3 like '%'+char(10)+'%'
select * from Member where address4 like '%'+char(13)+'%' or address4 like '%'+char(10)+'%'
2.Refer to the result list, edit or delete (and re-enter) all detected addresses. (You are not required to do another excel import)
3.Perform sync again
By: CK 20230209, Jacky 20230323, P230323 [000398]
|
AutoCount Accounting 1.8 / 1.9
|
|
AutoCount Payroll
|
|
AutoCount POS
|
|
AutoCount On The Go
|
|
AutoCount Accounting Plug-In Documentations
|