Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
Remove Intercompany Transactions on A/R Aging Report
Documented below are the steps to exclude Intercompany Transactions on the A/R Aging Report (Consolidated Level):
1. Navigate to Reports > Customers/Receivables > AR Aging > Customize
2. Click on Filters Link and assign the following:
a. Expand Unpaid Receivables folder > Select Entity (Line) = Not Equal to (Intercompany Customers/Vendors)
b. Expand Customer/Project folder > Select Name = Not Equal to Intercompany Customers/Vendors
c. Click on Save.
NOTE:
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
Kindly mark "Yes" if you find the reply to your question as helpful. This will aid the community to find the solution/answer much easier. Let's always mark a reply and help the community! ☺️
Shamaine Chan-Oracle | Ask a Guru