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

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)

000370-a.png


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


2. Type in: " update pospayment set custompaymenttype ='TNG' where dockey in (select dockey from pos where docno ='T01-000021') and paymenttype =9 " and click on Execute button.


3. T01-000021 is Document Number and TNG is one of custom payment type, you may replace which document number and custom payment type that you want to do amendment.


--Source from AutoCount Wiki --

    • Related Articles

    • A2.61 : Voucher Type Maintenance

      Question : What is Voucher Type Maintenance for in POS5 Backend ? Solution : Voucher Type Maintenance is a feature which enable you to categorize your vouchers. 1. In POS back-end, go to Point of Sale > Maintenance > Voucher Type Maintenance. Press ...
    • A2.39 : How to separate payment numbers when perform pos posting?

      Question : How to separate payment numbers when perform pos posting? Example : Below is an example of summary report where Payment Numbers are grouped (not to post separately) by the same Payment method. Below is an example of summary report where ...
    • UBSA1.163 : Access UBS (Accounting): Error: 'Transaction no. missing'

      DescriptionError- Transaction no. missing appears when running a scan batch. EnvironmentAccess UBS (Accounting) Solution To resolve this issue follow the below steps: Go to Housekeeping, then File Organization. Select Mark All. Click Ok. --Source ...
    • 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. Pos3/5/FNB: How to resync one specific pos transaction by using ...
    • A2.36 : How to Change Payment Posting Account?

      Question : My account department has added a bank account for POS payment method. How to set posting to this new account. Solution : For Cash & Cheque : 1a. Go to Stock > Stock Location Maintenance 1b.Select your POS Location > Edit 1c.Click on POS ...