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

Hi
I'm trying to add a saved search for Items with no sales transactions for a particular period.
I tried with this method: <http://www.netsuiterp.com/2018/09/search-for-items-with-no-sales.html>. But I didn't get a satisfactory result.
I hope advice from experienced consultant. thank you

What have you tried?
What result did you get?
How was that result unsatisfactory?

first of all, I created a new search that return all assembly and inventory items

const itemSearch = search.create({
        type: 'item',
        filters: [{
          name: 'type',
          operator: 'anyof',
          values: [
            search.Type.ASSEMBLY_ITEM,
            search.Type.INVENTORY_ITEM
          ]
        }],
        columns: [
          search.createColumn({
            name: 'internalid'
          })
        ]
      });

but it returns no result

Compare the type values used by N/search for filtering item types to the values of the search.Type enum.