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.

2. Go to Tools > SQL Query

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

ALTER TABLE PosDtl ADD Modifier nvarchar(MAX) NULL

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 & 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 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