Query
When I run my A/P aging report, all of the Intercompany vendor records are present with aging over 90 days. It appears the offset to each of those records is the “no vendor” record.
Can someone help me understand why this could be happening? Ideally, these would not show up.
Solution
When you run an A/P aging, every account within your COA with type=accounts payable will be included.
You can easily filter your report to not equal your intercompany accounts, by clicking customize, filters, account not equal to (define the specific intercompany accounts).
Angela is correct, the A/P and A/R aging report includes all Account Payables and Accounts Receivable type of accounts respectively, regardless of whether it is an elimination account.
We can customize the report to exclude it:
1.) Navigate to Reports > Vendors/Payables > Details or Summary
2.) Click Customize
3.) Go to Filters Section
4.) Add Fields > Expand Open Payables folder > Add Fields>Open Payables>Due To/From Subsidiary > set to Empty
Upon checking this is the standard behavior in Aging reports.
There was even a SuiteAnswers dedicated for this alternate solution under SuiteAnswers: 35756 | Customize A/R Aging Report to Exclude Intercompany Transactions on the AR Aging Report (Consolidated Level)