Transaction Searches Returning Duplicate Results

While we’re on the topic of Search Filters, Shane had this question today in my Coaching program :

Would you be able to help me here. I am looking at Item Fulfillments and displaying each item associated with it which in this case is 1 item. The problem I’m having is, when I create my search and loop through it, it is finding 3 that seem identical.

var mySearch = search.create({
    columns: ["tranid", "item", "quantity", "item.displayname","location", "item.itemid", "status", "entity", "statusRef"],
    filters: ["tranid", "is", "IF15"]
}).run().each(function (items) {
    return true;

Any idea?

Great question, Shane! Yes I do have an idea!

You’re seeing the seemingly identical results because of how Transaction Searches behave in NetSuite; in order to narrow down your results correctly, you’ll want to research and understand the mainline filter:

{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}

Related posts

March 3, 2021

Does the physical location of a competent employee change the amount of value they can deliver for your organization? If it does, I’d be keen to hear your story. If it does not, why ...

Read More

March 2, 2021

Today a friend and former colleague of mine – who happens to now be in a development leadership role for a NetSuite partner – was lamenting the extreme difficulty of finding and hiring NetSuite ...

Read More

March 1, 2021

Software is never finished; clients are always changing and re-prioritizing. NetSuite is ever a moving target – always updating and evolving. Market forces are always shifting and shoving, forcing new demands on your business. ...

Read More