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({
    type: "ITEMFULFILLMENT",
    columns: ["tranid", "item", "quantity", "item.displayname","location", "item.itemid", "status", "entity", "statusRef"],
    filters: ["tranid", "is", "IF15"]
}).run().each(function (items) {
    form.addField({...});
    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

January 7, 2021

Anything I wrote today about business would both feel and be inadequate. I simply can’t arrive at the words to express how I feel in this moment. So instead, here are a few helpful ...

Read More

December 20, 2020

2020 was a hundred swift kicks to the shorts and one giant kick in the ass. If you’ve lost people you love, if you’ve gotten sick or hurt, if you’ve lost your job, if ...

Read More

December 16, 2020

“I’ve been meaning to learn SuiteScript, but it’s hard to find the time …”“We’re slammed, and I just don’t have the time …”“I haven’t made the time …” All are variations of a theme ...

Read More

December 14, 2020

Last week we looked at mimicking the functionality of a REST endpoint with its own module (e.g. retrieving a User, or a list of Users, refreshing a token, etc). For complex integrations that rely on a large ...

Read More