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

From AutoCount Resource Center
Revision as of 08:16, 30 August 2021 by PeterT (talk | contribs) (Created page with "<u><b>Question :</b></u> When perform synchronization, system will show error message "Column 'Modifier' not belongs to posdtl"? <u><b>Solution :</b></u> User upgraded pos...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

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

IconAcc20.PNG AutoCount Accounting 2.0


IconAcc188.PNG AutoCount Accounting 1.8 / 1.9
Wiki-Payroll.png AutoCount Payroll
Wiki-POS.PNG AutoCount POS


Wiki-AOTG.PNG AutoCount On The Go
Wiki-Accounting-Plugin.png AutoCount Accounting Plug-In Documentations