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!
Sales Order - Advanced Project join
I am struggling with the join between these two tables.
I have one saved search based on Project and with these criteria
Project Resource Role is Project Manager
Start Date is on or after 1/3/2011
Transaction : Type is Sales Order
and results from both the project and the transaction tables.
And what I get is one row for every project (perfect!)
I just created another saved search based on Project with different criteria and results (less fields from transaction and the field I have used is on the first search too) and this time I'm getting one row for every Sales Order line.
0