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.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Stay in the Know
Be sure you're subscribed to NetSuite communication to stay in the know about monthly happenings, updates and announcements. Subscribe
Be sure you're subscribed to NetSuite communication to stay in the know about monthly happenings, updates and announcements. Subscribe
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