Pos: Sync Error - Cannot set column ‘ItemGroup’. The value violates the MaxLength limit of this column

Question: Sync error - Cannot set column ‘ItemGroup’. The value violates the MaxLength limit of this column.



Possible Reason:

Length of "ItemGroup" in outlet setting is not the same as HQ.


Solution:

1. Look into the PC at outlet, go to AutoCount Management Studio

2. Go to Tools > Change User > Defined Data Types Size



3. For the related data type name, make sure the size value is the same as HQ.



For POS 5.X or FnB ref below link:

https://wiki.autocountsoft.com/wiki/Pos3/5/FNB:_Sync_Error_-_Cannot_set_column_%E2%80%98ItemGroup%E2%80%99._The_value_violates_the_MaxLength_limit_of_this_column


By:Kim Seng 20170728, KM 20170802; P170810

Go to menu

  AutoCount Accounting 2.0 & 2.1


  AutoCount Accounting 1.8 / 1.9
  AutoCount Payroll
  AutoCount POS


  AutoCount On The Go
  AutoCount Accounting Plug-In Documentations