Pos3/5/FNB: When perform synchronization, system will show error message “Column ‘Modifier’ does not belong to table posdtl”. #
Error Message #
Column ‘Modifier’ does not belong to table PosDtl.
NOTE: This error normally happens when user upgraded Autocount POS version from POS 3 to POS 5, and the Posdtl table is missing Modifier column, so cause the synchronization interrupted.
Step 1: Open Autocount POS Management Studio in Windows Start Menu, and login to the correct account book.
Step 2: Go to Tools > SQL Query.
Step 3: 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.