A1.119 : Prompted Message: Change Account No Error-The Delete statement conflicted with the REFERENCE constraint “FK BonusPointRedemption Debtor”
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.
--Source from AutoCount Wiki --
Related Articles
A1.117 : Prompted Message: Error during upgrade to 2.0-Invalid Data Definition Language Statement, error message is Violation of PRIMARY KEY constraint … The duplicate key value is (CR Default)
Question: When upgrade database from 1.9 to 2.0, error message prompted “Invalid Data Definition Language Statement, error message is Violation of PRMIARY KEY constraint … The duplicate key value is (CR Default). Why? After clicking OK, another ...A5.87 : Accounting - Reports : Debtor Statement
This function allows you to generate Debtor Statement. Debtor Statement is used to show all financial activities between you and each of your debtor within a specific period. It is usually sent to debtors at regular interval to gently remind them on ...Autocount : Debtor Maintenance
Debtor Maintenance This is to maintain debtor account. Go to A/R > Debtor Maintenance Debtor listing will be displayed. Click on Create a New Debtor, Control Account: choose the control account for this debtor Debtor Type: select a debtor type (for ...A1.113 : Prompted Message: Error during upgrade to 2-Invalid Data Definition Language Statement and ALTER TABLE dbo.ADVQT…Guid
Question: When upgrade database from 1.9 to version 2.0, error message prompted “Invalid Data Definition Language Statement, error message is Column already has a DEFAULT bound to it”. After click OK, another message prompted “ALTER TABLE ...A1.102 : Prompted Message: Change Item Code error – Invalid column name ‘Key1’
Question: When I try to change item code, error prompted: Invalid column name ‘Key1’. Why? Version: 2.0 Possible Reason : The database detected POS 3 is installed, the database is upgraded from version 1.9 to 2.0, but the POS table is not updated. ...