Customers Who Have NOT Purchased a Specific Item

Hi,  I am looking to create a report (or saved search) of customers who have NOT purchased a particular item. I want the user to be able to enter the item in a filter, and not have to edit the report or search criteria.  Does anyone have suggestions on how to achieve this?

Rookie Asked on September 26, 2022 in Reports.
Add Comment
3 Answer(s)

Hi there! Were you able to receive responses from other members privately?

Could you please tell me more about the challenges that you’ve encountered with NS recently? My team might be able to help you with that. 🙂

Rookie Answered on September 26, 2022.
Add Comment

In a Customer record saved search, set the criteria logic to be,

    • Return a list of customers where the transaction/item’s ID is –None–


Rookie Answered on March 20, 2023.
Add Comment

I tried this without success.  According to NetSuite support, this is not possible, but I have known them to be wrong before. Have you gotten it to work with user-entered criteria in the filter?

Rookie Answered on April 17, 2023.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Become a Sponsor   Become a Sponsor