July 18, 2017

Line Filters in SuiteScript

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


  • 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:

    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]

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

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