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
This issue happens when the debtor is selected in Bonus Point Redemption.

Fkbonuspointredemption debtor3.png


Update to version 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