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.
How to create a Saved Search to count lines and compare?
Hello SMEs,
On the line level, I have a custom column - a checkbox.
I need to have a saved search wherein it will only display the transaction (PO) if all the lines are checked.
For example:
- PO 123 has 3 lines, and out of the 3 lines only 2 has the checkbox ticked/set to true
- PO 456 has 5 lines, all 5 line items has the checkbox set to true
Result of the saved search should only show PO 456
Or is there a non-scripting option wherein it will count all the line items, put the value on a custom header field and then another custom header field which will count & display the number of lines where the checkbox is set to true/ticked.
Tagged:
0