A2.32 : How to resync one specific pos transaction by using SQL query command?

A2.32 : How to resync one specific pos transaction by using SQL query command?

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.

000369-a.png


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

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.

000369-a.png


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.


--Source from AutoCount Wiki --


    • Related Articles

    • A2.148 : How to re-assign a missing pos transaction custom payment type?

      Question : How to re-assign a missing pos transaction custom payment type? Solution : Dealer discretion is advised. We can only use SQL query command to re-assign the custom payment type (this query is advisable to run at POS Front End) 1. First, go ...

    • A2.108 : How to set windows firewall exception for sql port?

      Question : How to set windows firewall exception for sql port? Solution : User may need to set windows firewall exception for sql port if user unable to link up Autocount system by using sql port. 1. Press Win + R to open run command, and fill in ...

    • A2.120 : POS How to check Microsoft SQL instance port number?

      Question : I want to open firewall port setting for AutoCount system, how can I know which port number is used by AutoCount? Solution : 1st way is you can use AutoCount SQLUtility.exe to check If normal store in AutoCount Full Setup CD > ...

    • A2.109 : How to configure dynamic and static sql port number?

      Question : How to configure dynamic and static sql port number for security purpose as I do not want to open all my ports? Solution : User may configure sql port number in SQL Server configuration manager. Using SQL Port number to link up system, may ...

    • A2.37 : How to do batch repost transaction?

      Question : How to do batch repost transaction? Solution : User would like to do repost transaction by batch instead of one by one. 1. Login to POS Management Studio, Go to Data Consistency > Repost POS Transaction 2. Select Date Range & Outlet and ...