Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Please note that on Saturday, April 11, 2026, at 8:00 PM Pacific time, our Case Management System will undergo a scheduled maintenance for approximately 30 minutes. During this time, case creation via SuiteAnswers will be unavailable and inbound calls will be routed to Customer Service.
How to create Sales Order Saved Search with all related invoices?
Hello there, i'm trying to pull a saved transaction search which will group by Sales order, with all related invoices showing on drill down, but only as one line items, with document number, invoice amount, and status. At the moment the Invoices are showing as multiple transaction lines, and both the Sales order total and the sum of all invoice lines is obviously incorrect, is there any method or formula i can use that will list the Sales Order doc number and amount, and at drill down the list of invoice doc numbers and totals as one line items
Tagged:
0