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 18, 2026, at 8:00 PM Pacific Time, our Case Management System will undergo a scheduled maintenance for approximately 15 minutes. During this time, case creation via SuiteAnswers will be unavailable and inbound calls will be routed to Customer Service.
Project Saved Search with Multiple Sales Orders
Hello,
I am using a Project Saved Search with basic information. I would like to add Sales Order# and Sales Order Amount to the search. There are scenarios where more than one Sales Order is attached to one project, in such case
Summary type = maximum and
Formula Text = CASE WHEN {transaction.type} = 'Sales Order' THEN {transaction.number} END
only returns one line
If I use summary type = group, then duplicate line with -None- is displayed for the Project with SOs attached.
I do not want to use criteria to filter the results by type = Sales Order as we also want to display Projects with no Sales Order
0