- Navigate to Reports > Customers/Receivables > AR Aging > Customize.
- Click on Filters Link and assign the following:
- Expand Unpaid Receivables folder>select Entity (Line) = Not Equal to Intercompany Customers/Vendors
- Expand Unpaid Receivables folder>select Subsidiary=Not Equal to Elimination Subsidiary
- Expand Customer/Project folder>select Name= Not Equal to Intercompany Customers/Vendors
- Click Save
Removing the Intercompany Transactions will not affect the total amount of the AR Aging Report since the amounts that are being taken out are offsetting (The original Transaction and the Elimination Entry). The total amount should still balance with the Accounts Receivable balance in the Balance Sheet.
No comments:
Post a Comment