Pos3/5/FNB: Sync error PosEventLog UserID

From AutoCount Resource Center

Question :

During sync POS Event Log data come out User ID error, why?

Synchronizer Error: {‘Message ‘:’ Foreign Key Error (Constraint Name = FK_PosEventLog_UserID)’}.


Possible Reason :

Most probably is user has changed or deleted POS User ID.

Solution :

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


2. Go to Tools > SQL Query > enter Password (if you don’t know please contact your software provider)> OK


3. Enter the following query statement > click Execute

Select * from PosEventLog

At filter, click on the filter icon as shown below. Double check all the UserID and to compare with your server PosUserID.


If there is PosUserID being shown here but does not exist in server, its mean you have deleted this PosUserID. Please add back this POS User ID.

if the UserID is blank, you will need to run this query:

update PosEventLog set UserID = 'ADMIN' where UserID = ''

4. Perform speed sync again.

By: CK 20230515, Jacky 20230523, P230523 [000414]

Go to menu

IconAcc20.PNG AutoCount Accounting 2.0 & 2.1

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