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!
Need to report all items in the order even if one item satisfies the condition
Gurus,
The saved search is working good if at least one item is satisfying a name pattern, then the result from the saved search is displaying that item. I use summary criteria/formula(numeric)/sum/CASE WHEN INSTR({item.name},'ABCD-')>0 THEN 1 ELSE 0 END
However, the issue is the saved search is retrieving only the items that satisfied the condition 'ABCD' anywhere in the item name. What I am looking for is to get all the items in the result if the above criteria is met.
In this case if there are two items in the sales order matching with string 'ABCD' out of 10 items, my saved search above retrieves only two items. But I would need all the 10 items if it satisfies the above condition.
0