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!
Find customers that have ordered at least two of a list of items
I need to create a search that will return all customers that have ordered at least two of the following:
[LIST]
[*]widgetA
[*]widgetB
[*]widgetC
[*]widgetD
[*]widgetE[/LIST]
I'm tried this a couple different ways and I'm thinking that the Items Ordered filter on the Customer search doesn't do what I think it should.
For example, I created a search with an Items Ordered filter set to "All Of" WidgetA, WidgetB. I would interpret this as "Select all the customers that have orders WidgetA AND WidgetB"
Well, the search returns zero results. I have a customer that I'm looking at, I can see two sales orders, one with WidgetA and another with WidgetB.
Steve Klett | Senior Developer
NetValue Technology