Optical Pos: How to re-sync batch bill back to HQ?: Difference between revisions
(Created page with "<u><b>Question :</b></u> How can I resync previous transaction back to HQ server again? <u><b>Solution :</b></u> 1. Login <span style='color:red'>Frontend Optical POS</span> > <span style='color:red'>Optical Pos </span>menu > <span style='color:red'>Tools</span> > <span style='color:red'>Options</span> > <span style='color:red'>SQL Query</span> > enter <span style='color:red'>Password</span> (if don’t know please contact your software provider) > <span style='color...") |
No edit summary |
||
Line 15: | Line 15: | ||
[[File:000415-b.png]] |
[[File:000415-b.png]] |
||
update TM_OP set Synced = 'F' where docdate >= '20230328' and docdate <= '20230331'</span> |
<span style='color:red'>update TM_OP set Synced = 'F' where docdate >= '20230328' and docdate <= '20230331'</span> |
||
update TM_OP set Synced = 'F' where docdate >= 'FromDateYYYYMMDD' and docdate <= ' ToDateYYYYMMDD' |
<span style='color:blue'>update TM_OP set Synced = 'F' where docdate >= 'FromDateYYYYMMDD' and docdate <= ' ToDateYYYYMMDD'</span> |
||
3. Erase all exiting query > enter the following new query > Execute |
3. Erase all <span style='color:red'>exiting query</span> > enter the following <span style='color:red'>new query</span> > <span style='color:red'>Execute</span> |
||
[[File:000415-c.png]] |
[[File:000415-c.png]] |
||
update TM_OP set Synced = 'F' where dockey in (select dockey from TM_OPPayment where paymentdate >= '20230328' and paymentdate <= '20230331') |
<span style='color:red'>update TM_OP set Synced = 'F' where dockey in (select dockey from TM_OPPayment where paymentdate >= '20230328' and paymentdate <= '20230331')</span> |
||
update TM_OP set Synced = 'F' where dockey in (select dockey from TM_OPPayment where paymentdate >= 'FromDateYYYYMMDD' and paymentdate <= ' ToDateYYYYMMDD') |
<span style='color:blue'>update TM_OP set Synced = 'F' where dockey in (select dockey from TM_OPPayment where paymentdate >= 'FromDateYYYYMMDD' and paymentdate <= ' ToDateYYYYMMDD')</span> |
||
4. Erase all exiting query > enter the following new query > Execute |
4. Erase all <span style='color:red'>exiting query</span> > enter the following <span style='color:red'>new query</span> > <span style='color:red'>Execute</span> |
||
[[File:000415-d.png]] |
[[File:000415-d.png]] |
||
update TM_OP set Synced = 'F' where dockey in (select dockey from TM_OPStockDtl where stockdate >= '20230328' and stockdate <= '20230331') |
<span style='color:red'>update TM_OP set Synced = 'F' where dockey in (select dockey from TM_OPStockDtl where stockdate >= '20230328' and stockdate <= '20230331')</span> |
||
update TM_OP set Synced = 'F' where dockey in (select dockey from TM_OPStockDtl where stockdate >= 'FromDateYYYYMMDD' and stockdate <= ' ToDateYYYYMMDD') |
<span style='color:blue'>update TM_OP set Synced = 'F' where dockey in (select dockey from TM_OPStockDtl where stockdate >= 'FromDateYYYYMMDD' and stockdate <= ' ToDateYYYYMMDD')</span> |
||
5. Erase all exiting query > enter the following new query > Execute |
5. Erase all <span style='color:red'>exiting query</span> > enter the following <span style='color:red'>new query</span> > <span style='color:red'>Execute</span> |
||
[[File:000415-e.png]] |
[[File:000415-e.png]] |
||
update TM_OPSession set Synced = 'F' where businessdate >= '20230328' and businessdate <= '20230331' |
<span style='color:red'>update TM_OPSession set Synced = 'F' where businessdate >= '20230328' and businessdate <= '20230331'</span> |
||
update TM_OPSession set Synced = 'F' where businessdate >= 'FromDateYYYYMMDD' and businessdate <= ' ToDateYYYYMMDD'. |
<span style='color:blue'>update TM_OPSession set Synced = 'F' where businessdate >= 'FromDateYYYYMMDD' and businessdate <= ' ToDateYYYYMMDD'</span>. |
||
6. Perform sync again. |
6. Perform <span style='color:red'>sync again</span>. |
||
**If you are not sure what you are doing, please do contact customer support for help regarding this. |
**If you are not sure what you are doing, please do contact customer support for help regarding this. |
Latest revision as of 06:45, 1 June 2023
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]
AutoCount Accounting 2.0 & 2.1
|
AutoCount Accounting 1.8 / 1.9
|
AutoCount Payroll
|
AutoCount POS
|
AutoCount On The Go
|
AutoCount Accounting Plug-In Documentations
|