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!
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