Pos3/5/FNB: Sync error PosSession UserID / Checkout User ID

Question :

During sync, I encounter a synchronization error as shown below.

PosSession: Synchronizer Error: {"Message":"Foreign Key Error (Constraint Name=FK_PosSession_UserID)"}

or

PosSession: Synchronizer Error: {"Message":"Foreign Key Error (Constraint Name=FK_PosSession_CheckoutUserID)"}

Possible Reason :

Most probably is that user had 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 PosSession

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

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

4. Perform speed sync again.

By: CK 20240708, Jacky 20240830 [000503]

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