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

From AutoCount Resource Center
Revision as of 07:05, 3 April 2024 by PeterT (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

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 1.8 / 1.9
AutoCount Payroll
AutoCount POS


AutoCount On The Go
AutoCount Accounting Plug-In Documentations