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

From AutoCount Resource Center

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?

Fkbonuspointredemption debtor1.png


Fkbonuspointredemption debtor2.png


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.


Fkbonuspointredemption debtor3.png


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

IconAcc20.PNG AutoCount Accounting 2.0 & 2.1


IconAcc188.PNG AutoCount Accounting 1.8 / 1.9
Wiki-Payroll.png AutoCount Payroll
Wiki-POS.PNG AutoCount POS


Wiki-AOTG.PNG AutoCount On The Go
Wiki-Accounting-Plugin.png AutoCount Accounting Plug-In Documentations