Accounting 2.0 - Prompted Message: Change Account No Error-The Delete statement conflicted with the REFERENCE constraint “FK BonusPointRedemption Debtor”: Difference between revisions

From AutoCount Resource Center
Content added Content deleted
(Created page with "'''Question:''' When I try to change account no, an error prompted: The DELETE statement conflicted with the REFERENCE constraint “FK_BonusPointRedemption_Debtor”. The conflict occurred in database “AED_XXX”, table “dbo.BonusPointRedemption”, column ‘DebtorCode’. Why? [File:Fkbonuspointredemption debtor1.png] [File:Fkbonuspointredemption debtor2.png] <u><b>Possible Reason:</b></u> This is a known bug and is fixed in version 2.1.0.1.<br/> This issue h...")
 
No edit summary
 
Line 1: Line 1:
'''Question:''' When I try to change account no, an error prompted: The DELETE statement conflicted with the REFERENCE constraint “FK_BonusPointRedemption_Debtor”. The conflict occurred in database “AED_XXX”, table “dbo.BonusPointRedemption”, column ‘DebtorCode’. Why?
'''Question:''' When I try to change account no, an error prompted: The DELETE statement conflicted with the REFERENCE constraint “FK_BonusPointRedemption_Debtor”. The conflict occurred in database “AED_XXX”, table “dbo.BonusPointRedemption”, column ‘DebtorCode’. Why?


[File:Fkbonuspointredemption debtor1.png]
[[File:Fkbonuspointredemption debtor1.png]]



[File:Fkbonuspointredemption debtor2.png]
[[File:Fkbonuspointredemption debtor2.png]]




Line 10: Line 11:
This is a known bug and is fixed in version 2.1.0.1.<br/>
This is a known bug and is fixed in version 2.1.0.1.<br/>
This issue happens when the debtor is selected in Bonus Point Redemption.
This issue happens when the debtor is selected in Bonus Point Redemption.


[[File:Fkbonuspointredemption debtor3.png]]




Line 15: Line 19:


<span style='color:red'>Update to version 2.1.0.1 or later</span>, and you should be able to perform change account number.
<span style='color:red'>Update to version 2.1.0.1 or later</span>, and you should be able to perform change account number.




By: Jodie 221109, Lay Swan 221124, P221125
By: Jodie 221109, Lay Swan 221124, P221125

Latest revision as of 03:00, 30 November 2022

Question: When I try to change account no, an error prompted: The DELETE statement conflicted with the REFERENCE constraint “FK_BonusPointRedemption_Debtor”. The conflict occurred in database “AED_XXX”, table “dbo.BonusPointRedemption”, column ‘DebtorCode’. Why?



Possible Reason:

This is a known bug and is fixed in version 2.1.0.1.
This issue happens when the debtor is selected in Bonus Point Redemption.



Solution:

Update to version 2.1.0.1 or later, and you should be able to perform change account number.


By: Jodie 221109, Lay Swan 221124, P221125



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