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

And then change Quantity to a Formula (Numeric) something like `DECODE({item}, 'Item to Filter', {quantity}, 0)`

michoel: hi michoel! you might (but probably not) recall i am generating a saved search that lists certain customers (via criteria) sales for an item. if the customer has a quantity of 0, they are listed as such. this has been working well but now when i give the search a criteria of a date range, some customers are mysteriously not appearing on the report at all. any clues surrounding this one?

Remind me, was this a Customer Saved Search, or a Transaction search?

transaction search. :slightly_smiling_face: everything is fine and dandy with the “date all” criteria but seems to stumble with a date range of anything.

Well it makes sense.. if you are filtering by date, then any customers with no transactions in that date period won't show up at all

I guess you need to put the condition in the results tab as part of the formula

Something like `CASE WHEN {trandate} &gt; [your date] AND {item} = [your item] THEN {quantity} ELSE 0 END`