Optical Pos: How to re-sync batch bill back to HQ?

Question :

How can I resync previous transaction back to HQ server again?

Solution :

1. Login Frontend Optical POS > Optical Pos menu > Tools > Options > SQL Query > enter Password (if don’t know please contact your software provider) > Proceed.

2. Enter the following query statement > Execute

update TM_OP set Synced = 'F' where docdate >= '20230328' and docdate <= '20230331'

update TM_OP set Synced = 'F' where docdate >= 'FromDateYYYYMMDD' and docdate <= ' ToDateYYYYMMDD'

3. Erase all exiting query > enter the following new query > Execute

update TM_OP set Synced = 'F' where dockey in (select dockey from TM_OPPayment where paymentdate >= '20230328' and paymentdate <= '20230331')

update TM_OP set Synced = 'F' where dockey in (select dockey from TM_OPPayment where paymentdate >= 'FromDateYYYYMMDD' and paymentdate <= ' ToDateYYYYMMDD')

4. Erase all exiting query > enter the following new query > Execute

update TM_OP set Synced = 'F' where dockey in (select dockey from TM_OPStockDtl where stockdate >= '20230328' and stockdate <= '20230331')

update TM_OP set Synced = 'F' where dockey in (select dockey from TM_OPStockDtl where stockdate >= 'FromDateYYYYMMDD' and stockdate <= ' ToDateYYYYMMDD')

5. Erase all exiting query > enter the following new query > Execute

update TM_OPSession set Synced = 'F' where businessdate >= '20230328' and businessdate <= '20230331'

update TM_OPSession set Synced = 'F' where businessdate >= 'FromDateYYYYMMDD' and businessdate <= ' ToDateYYYYMMDD'.

6. Perform sync again.

- If you are not sure what you are doing, please do contact customer support for help regarding this.

By: CK 20230515, Jacky 20230523, P230523 [000415]

Optical Pos: How to re-sync batch bill back to HQ?

Go to menu