Line Filters in SuiteScript

In addition to `mainline` I mentioned several sublist line filters in this week’s exploration of Transaction Searches.

Namely:

  • Main Line
  • Shipping Line
  • Tax Line
  • COGS Line

I showed an example that utilized all of these filters in the UI, but I did not show the corresponding script.

Here is what that same filter setup looks like in SuiteScript:

s.create({
    type: s.Type.SALES_ORDER,
    filters: [
        ["mainline", s.Operator.IS, false], "and",
        ["taxline", s.Operator.IS, false], "and",
        ["shipping", s.Operator.IS, false], "and",
        ["cogs", s.Operator.IS, false]
    ]
}).runPaged().count;

This Search will provide one result per Item line from every Sales Order in your account.

You can of course find all of these Filters in the Records Browser page for the “Transaction” Record Type; no need to memorize them.

{"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