Accounting 2.0 - Prompted Message: Change Account No Error-The Delete statement conflicted with the REFERENCE constraint “FK BonusPointRedemption Debtor”: Difference between revisions
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
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
|