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

From AutoCount Resource Center

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

Version : 1.8 / 1.9 / 2.0


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.


By : Ju Lee 190212, Lay Swan 190517, P190523


6) If there is no record on the existing sql query, please execute another sql query :
select * from obdtl where accno in (select accno from debtor where IsGroupCompany = 'T')


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


8) Look into the Source Type, RI stand for A/R Invoice, then execute the second query:

select * from ARInvoice where DebtorCode = '300-G001'

This is the affected document number, and you shall need to edit the affected transaction and change the debtor account (group company) to a sub company debtor or another debtor account.



9) Now you should be able to inquiry the Debtor Aging report after performed the above action.


Note : Please seek assistance from your software dealer if the problem still persists after performing the steps as above.



By : Park Yao 230717, Lay Swan 230719, P230721



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