Pos3/5/FNB: How to re-assign a missing pos transaction custom payment type?

Question :

How to re-assign a missing pos transaction custom payment type?

Error Message: Doc No. Foreign Key Error (Constraint Name=FK_PosPayment_CustomPaymentType)

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 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.

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

Go to menu

AutoCount Accounting 2.0 & 2.1 AutoCount Accounting 2.0 What's New AutoCount Accounting 2.0 Help File AutoCount Accounting 2.0 FAQ (Application) AutoCount Accounting 2.0 FAQ (Troubleshoot) AutoCount Accounting 2.0 Others AutoCount Accounting 2.0 Release Note AutoCount Accounting 2.1 Release Note AutoCount Accounting 2.2 Release Note

AutoCount Accounting 1.8 / 1.9 AutoCount Accounting 1.8 FAQ (Application) AutoCount Accounting 1.8 FAQ (Troubleshoot) AutoCount Accounting 1.8 / 1.9 Release Note

AutoCount Payroll

AutoCount POS

AutoCount On The Go

AutoCount Accounting Plug-In Documentations