Pos3/5/FNB: How to resync one specific pos transaction by using SQL query command?

From AutoCount Resource Center
Revision as of 02:18, 4 January 2023 by PeterT (talk | contribs) (Created page with "<u><b>Question :</b></u> How to resync one specific pos transaction by using SQL query command? <u><b>Solution :</b></u> **<b>Dealer discretion is advised.</b> This SQL query command can only be executed at POS Frontend. File:000369-a.png 1. First, go to <span style='color:red'>Autocount POS 5.0/5.1 Database Configuration</span> > <span style='color:red'>Tools</span> > <span style='color:red'>Sql Query</span> 2. Type in : " <span style='color:red'>update p...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Question :

How to resync one specific pos transaction by using SQL query command?


Solution :

    • Dealer discretion is advised.

This SQL query command can only be executed at POS Frontend.


1. First, go to Autocount POS 5.0/5.1 Database Configuration > Tools > Sql Query


2. Type in : " update pos set sync ='F' where docno ='T01-00003' " and click on Execute button.


3. T01-00003 is your Document Number that you wish to resync. You may replace the document number with the actual one.


By: Kee 20221216, Jacky 20221222, P221227 [000369]


Go to menu

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