A2.23 : How to Re-sync Batch Bill to HQ Server Backend again?

A2.23 : How to Re-sync Batch Bill to HQ Server Backend again?

Question :

My HQ account book/database is corrupted, the last backup was a week ago. How do I sync back my transaction from outlet as it is already synced before?


Solution :

You can resync from FE with little technical skill involved.

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


For Pos 3.0/3.1/5.0 :

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

000136-a.png


For F&B :

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

000136-b.png


1b. Click Configuration Setting

000136-c.png


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

000136-d.png


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

000136-e.png


Sample A: From Doc to Doc

Update POS set Sync = 'F' where Docno >= 'xxx' and Docno <= 'xxx'

Update POS set Sync = 'F' where Docno >= 'T030001' and Docno <= 'T030010'

Sample B: From time to time

Update POS set Sync = 'F' where Createdtime >= 'xxx' and Createdtime <= 'xxx'

Update POS set Sync = 'F' where Createdtime >= '2019-01-01 00:00:00' and Createdtime <= '2019-12-31 23:59:59'


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


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


6. Then perform synchronization.


--Source from AutoCount Wiki --
    • Related Articles

    • A2.24 : How to Re-sync Bill to HQ Server Backend?

      Question : I accidentally deleted a POS transaction on server database. What can I do right now? Solution : You can resync back the transaction that you deleted. To do so, For Pos 3.0/3.1/5.0 : 1a. Go to POS Frontend > More Function > Report For F&B ...
    • A2.22 : How to perform client sync at POS Backend instead of do sync at Frontend

      Question : How to perform client sync at POS Backend instead of do sync at Fronted? Solution : User wants to easy control client sync for all outlets at HQ Backend to get updated report. (Instead of do it one by one at all outlets) 1. Login to POS ...
    • A2.84 : How to setup HQ database connection

      Question : How to setup HQ database connection. Solution : For POS3: Configure the HQ database information at POS frontend. Login to your frontend and then go to More Function > Configuration Setting > Document Control 2 and configure your HQ ...
    • A2.30 : After restored FE DB, how to sync with HQ?

      Question : After restored FE DB, how to sync with HQ? Solution : 1. Go to Start Menu, click on Database Configuration under AutoCount Pos 5 Folder alternatively you may find database configuration application at C:\Program Files (x86)\AutoCount\FnB ...
    • A2.20 : How to use Service Bus Sync

      Question : I want my POS/F&B terminal to use Service Bus and sync with HQ. But how to get the Service Bus Name Space & Relay Name info? Solution : 1. Go to your Server, open POS 5.0 Server Monitor 2. Select your Backend Server Profile then click the ...