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

Revision as of 01:40, 30 November 2022 by LaySwan (talk | contribs) (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...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

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]


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