Troubleshooting: Error “This constraint cannot be enabled as not all values have corresponding parent values.” when inquiry Debtor Aging report: Difference between revisions
Troubleshooting: Error “This constraint cannot be enabled as not all values have corresponding parent values.” when inquiry Debtor Aging report (view source)
Revision as of 02:17, 27 July 2023
, 10 months agono edit summary
No edit summary |
No edit summary |
||
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]]
Line 37 ⟶ 63:
▲By : Ju Lee 190212, Lay Swan 190517, P190523
By : Park Yao 230717, Lay Swan 230719, P230721
{{NavigateForUser}}
| |||