Troubleshooting: Error “This constraint cannot be enabled as not all values have corresponding parent values.” when inquiry Debtor Aging report

Question : Error “This constraint cannot be enabled as not all values have corresponding parent values.” when inquiry Debtor Aging report.

Possible Reason :

Debtor account that was set as ‘Group Company’ contains transactions.

Solution :

1) Log in AutoCount Management Studio > Tools > SQL Query

2) Key in the following sql query and click on Execute:

select * from gldtl where accno in (select accno from debtor where IsGroupCompany = 'T')

3) Look into the result for AccNo, this is the Debtor Account that is marked as Group Company but contains transactions.

4) Go to Debtor maintenance to check on this Debtor, it is clear that “Group company” is checked.

5) From the sql query result, scroll to right to find RefNo1. This is the affected document number and you shall need to edit all these transactions and change the debtor account (group company) to a sub company debtor or another debtor account.