Pos3/5/FNB: When perform synchronization, system will show error message "Column 'Modifier' not belongs to posdtl"?

Question :

When perform synchronization, system will show error message "Column 'Modifier' not belongs to posdtl"?


Solution :

User upgraded pos version from POS 3 to POS 5, and the Posdtl table is missing Modifier column, so cause the synchronization interrupted.


1. Open Autocount POS Management Studio in Windows Start Menu, and login to the correct account book.

000238-a.png


2. Go to Tools > SQL Query

000238-b.png


3. Just copy and paste the following query onto SQL Query command and click Execute.

ALTER TABLE PosDtl ADD Modifier nvarchar(MAX) NULL

000238-c.png


Note : only POS Backend account book need to run this query command.


By: Kee 20210814, Jacky 20210824, P210826 [000238]


Go to menu

  AutoCount Accounting 2.0


  AutoCount Accounting 1.8 / 1.9
  AutoCount Payroll
  AutoCount POS


  AutoCount On The Go
  AutoCount Accounting Plug-In Documentations