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

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.

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.

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

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')

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')

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

By: Kim Seng 170915, CY 170921, P170928

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