Pos3/5/FNB: Sync error UDF Column names in each table must be unique

Question :

When I perform full sync, I had encounter error message as show below.

Unknown Sql Exception (Number=2705, Message=Column names in each table must be unique. Column name 'UDF Column Name' in table 'Table Name' is specified more than once.)

My sample:

Unknown Sql Exception (Number=2705, Message = Column names in each table must be unique. Column name 'UDF_Promoter' in table 'Member' is specified more than once.)

Possible Reason :

There is some issue regarding SQL table during creation for this UDF due to this UDF already exists.

Solution :

1. Go to Windows Start Menu > AutoCount POS / FnB Database Configuration

2. Go to Tools > SQL Query > Password > OK

3. Fill in below statement > Execute

ALTER TABLE TableName DROP COLUMN UDFColumnName

My sample is:

ALTER TABLE Member DROP COLUMN UDF_Promoter

4. Do full sync again

By: CK 20240912, Jacky 20240923 [000509]

Go to menu

AutoCount Accounting 2.0 & 2.1 AutoCount Accounting 2.0 What's New AutoCount Accounting 2.0 Help File AutoCount Accounting 2.0 FAQ (Application) AutoCount Accounting 2.0 FAQ (Troubleshoot) AutoCount Accounting 2.0 Others AutoCount Accounting 2.0 Release Note AutoCount Accounting 2.1 Release Note AutoCount Accounting 2.2 Release Note

AutoCount Accounting 1.8 / 1.9 AutoCount Accounting 1.8 FAQ (Application) AutoCount Accounting 1.8 FAQ (Troubleshoot) AutoCount Accounting 1.8 / 1.9 Release Note

AutoCount Payroll

AutoCount POS

AutoCount On The Go

AutoCount Accounting Plug-In Documentations