Pos3/5/FNB: How to Re-sync Batch Cash In and Cash Out Records?

Question :

My HQ account book/database is corrupted, the last backup was a week ago. How can I sync the cash in & cash out records back from outlet as it was synced from HQ earlier?

Solution :

You can resync from FE with SQL query.

PS: Backup FE first before performing this as it may lead to data corrupt or mismatch. Please call for support if there are any questions.

For Pos 3.x/5.x :

1. Go to POS Frontend > More Function > Configuration Setting

For F&B :

1a. Go to F&B Frontend > More Function > Setting

1b. Click Configuration Setting

2. Click on Miscellaneous tab > SQL Query > Password (ask from software provider) > OK

3. Key in the statement > highlight the query > Execute

Sample:

update poscashrecord set sync = 'F' where datetime >= 'xxx' and datetime < 'xxx'

update poscashrecord set sync = 'F' where datetime >= '2023-10-01 00:00:00' and datetime < '2023-10-31 23:59:59'

4. Copy the query below and paste it onto SQL query windows then click on Execute.

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

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

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

By: CK 20231031, Jacky 20231121, P231122 [000470]

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