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.