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.
POS Session in outlet did not sync back to HQ, but the POS Session Sync flag in outlet already set to “True”.
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
|AutoCount Accounting 2.0
|AutoCount Accounting 1.8 / 1.9
|AutoCount On The Go
|AutoCount Accounting Plug-In Documentations