Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
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.