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!
Don’t miss your chance to meet our SuiteGurus—NetSuite Support professionals and subject matter experts with extensive experience in select product areas, including OneWorld, Advanced & Basic Accounting, Supply Chain Management, Receivables & Payables, CRM, Account Administration, and the SuiteCloud Platform. Full Conference attendees can prebook exclusive 30-minute one-on-one sessions for your product questions.
Spots are limited! Register through your Agenda Builder and find SuiteGuru under Agenda Enhancements.
Total Sales over set time used for Criteria of a Saved Search
I'm trying to create a saved search that only returns customers who have spent "x" amount of money and placed "x" number of orders with us over a set period of time.
I have a saved search created that shows all customers with their number of orders and total dollars spent over a set time. Now I would like to filter out certain customers based on that information.
Is it possible to set criteria to accomplish this?
If I can't accomplish this solely using the saved search above, I figured I could create a workflow that would use the saved search to populate custom fields on the customer record to store the data I'm trying to use, then create another saved search using the custom fields in the criteria to get my final list. I'm just trying to keep it as simple as possible.