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