This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

In a saved search is the Summary and Standard criteria treated as an "and" or an "or". Trying to get customers who's maximum invoice data is between a date range. I'm getting customers who have an invoice in the date range specified in the summary but another invoice exists after the summary criteria range exists which I thought would be excluded.

For each, individually, I think it should be "AND". You could try to click on the "USE EXPRESSIONS" checkbox and select "AND" explicitly.

When used together though, Summary criteria should be equivalent to an SQL HAVING clause, which would be performed AFTER an aggregation.

So if the search results are not summarized, I'm not sure that the Summary criteria will be applied.

Can you post a screenshot of the criteria and results tabs?