Pos3/5/FNB: Sync Error POS Session

Question :

I have some sync error and when I check I get this error.

Error Message: Foreign Key Error (Constraint Name=FK_Pos_Session).

Possible Reason :

POS Session record is synced to older server database.

Solution :

1a. Login POS > More Function > Configuration Setting > Miscellaneous > SQL Query > Enter Password > OK > Copy the query below and paste onto SQL query windows > Execute.

1b. Login FnB > More Function > Setting > Configuration Setting > Miscellaneous > SQL Query > Enter Password > OK > Copy the query below and paste onto SQL query windows > Execute.

UPDATE POS SET Sync = 'F' WHERE SyncErrorMessage is not NULL

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

3.Erase previous query, copy the query below and paste onto SQL query windows then click on Execute.

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

3.Perfom speed sync on outlet system.

PS: If you are not confident in doing so, you may call our support or your dealer to help you with it.

By: CK 20220404, Jacky 220422, P220425 [000319]

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