Pos:Sync Error - Error found while sync Pos from Terminal to HQ

From AutoCount Resource Center
Jump to navigation Jump to search

Question: Sync Error - Error found while sync Pos from Terminal to HQ. It will stop sync Pos for this session. The value of column Session in table Pos does not exist in its master file.


Outlet sync1.png


Possible Reason:

POS Session in outlet did not sync back to HQ, but the POS Session Sync flag in outlet already set to “True”.


Solution:

Update the POS Session Sync flag in outlet computer manually using SQL query.

**Note: Please consult our technical support if you are not familiar with SQL query.

Step 1: Login into AutoCount Accounting Management Studio. Under Tools menu, look for SQL query and click on it.


Outlet sync2.png


Step 2: Click on Yes if you understand the risk and you want to continue.


Outlet sync3.png


Step 3: Copy the query below and paste into SQL query windows then click on Execute.

UPDATE PosSession SET Sync = 'F' WHERE SessionKey IN (SELECT Session FROM POS WHERE Sync = 'F')

Outlet sync4.png


Step 4: Erase previous query, copy the query below and paste into SQL query windows then click on Execute.

UPDATE PosSubSession SET Sync = 'F' WHERE SubSessionKey IN (SELECT SubSession FROM POS WHERE Sync = 'F')


Outlet sync5.png


Step 5: Close the AutoCount Accounting Management Studio and retry the AutoCount POS sync.


By: Kim Seng 170915, CY 170921, P170928

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