Pos3/5/FNB: How to re-assign a missing pos transaction custom payment type?: Difference between revisions
(Created page with "<u><b>Question :</b></u> How to re-assign a missing pos transaction custom payment type? <u><b>Solution :</b></u> **<b>Dealer discretion is advised. </b> We can only use SQL query command to re-assign the custom payment type (this query is advisable to run at POS Front End) File:000370-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</sp...") |
No edit summary |
||
Line 2: | Line 2: | ||
How to re-assign a missing pos transaction custom payment type? |
How to re-assign a missing pos transaction custom payment type? |
||
<span style='color:red'>Error Message: Doc No. Foreign Key Error (Constraint Name=FK_PosPayment_CustomPaymentType)</span> |
|||
Revision as of 07:05, 3 April 2024
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]
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
|