Pos3/Pos5/FNB: How to Re-sync Batch Bill to HQ Server Backend again?: Difference between revisions
Pos3/Pos5/FNB: How to Re-sync Batch Bill to HQ Server Backend again? (view source)
Revision as of 04:51, 12 November 2021
, 2 years agono edit summary
(Created page with "<u><b>Question :</b></u> 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 befor...") |
No edit summary |
||
Line 53:
4.
<span style='color:red'>UPDATE PosSession SET Sync = 'F' WHERE SessionKey IN (SELECT Session FROM POS WHERE Sync = 'F')</span>
[[File:Outlet sync4.png]]
5. <span style='color:red'>Erase previous query</span>, copy the query below and paste into SQL query windows then click on Execute.
<span style='color:red'>UPDATE PosSubSession SET Sync = 'F' WHERE SubSessionKey IN (SELECT SubSession FROM POS WHERE Sync = 'F')</span>
[[File:Outlet sync5.png]]
6. Then <span style='color:red'>perform synchronization</span>.
| |||