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

From AutoCount Resource Center
Content added Content deleted
No edit summary
No edit summary
 
Line 31: Line 31:




⚫
By : Ju Lee 190212, Lay Swan 190517, P190523
⚫
6) Now you should be able to inquiry the Debtor Aging report after performed the above action.


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

[[File:Aging constraint1.png]]


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

[[File:Aging constraint2.png]]


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

select * from ARInvoice where DebtorCode = '300-G001'<br/>

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.

[[File:Aging constraint3.png]]


[[File:Aging constraint4.png]]


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




Line 37: Line 63:





⚫
By : Ju Lee 190212, Lay Swan 190517, P190523

By : Park Yao 230717, Lay Swan 230719, P230721




{{NavigateForUser}}
{{NavigateForUser}}

Latest revision as of 02:17, 27 July 2023

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
Retrieved from "https://wiki.autocountsoft.com/wiki/Troubleshooting:_Error_“This_constraint_cannot_be_enabled_as_not_all_values_have_corresponding_parent_values.”_when_inquiry_Debtor_Aging_report?oldid=23906"