Skip to main content

Saved Search Filters

The Saved Search Filters pane is one of the panes in the Finsyte Preferences dialog, opened from Help > Preferences in the Finsyte ribbon.

Register NetSuite saved searches as Excel functions with filter parameters from Finsyte Preferences, and configure the filters each function accepts.

The Saved Search Filters preferences pane registers saved searches as custom saved search functions named FSN.SavedSearch.YourFunctionName. Each filter you configure becomes an argument of the function, in the order you arrange them. A filter can use any available field on the search's record type or on a record the search joins, whether or not the search already filters on it in NetSuite.

Important: This feature uses the Finsyte SuiteApp in NetSuite. To set it up, see the Finsyte SuiteApp instructions, and contact support (opens in new tab) with any questions. Filters on joined-record fields use the latest SuiteApp (Saved Search RESTlet 2.11.0): when SuiteApp Deploy shows Update available, select Deploy to NetSuite first.

Note: Registered saved search functions apply to the entirety of a company, not on an individual Finsyte license basis. Saved changes sync to other Finsyte users at your company. If your company has an administrator, company administrators change Saved Search Filters, and other users can view the pane.

  1. Select Help > Preferences
  2. Select Saved Search Filters on the left hand side
  3. Under Searches Available, locate the saved search you want to register. Use the search box to filter the list by name.
  4. Select Add > (or double-click the search) to register it. It will appear under Registered Functions.
  5. Optionally, double-click the Function name cell to rename the function. Use a unique name that starts with a letter and contains letters, numbers, and underscores.
  6. Select your chosen function and choose Edit Filters to configure the filters it accepts. See Configuring Filter Parameters for details.
  7. Select Save, then close and restart Excel for your new functions to become available. Saved Search Filters preferences pane

Note: Restart Excel to apply your changes.

Configuring Filter Parameters

  1. Under Registered Functions, select a function and choose Edit Filters.
  2. In the Configure filters dialog, Available fields lists the fields you can filter on, with their count. It includes the search's record type fields and the joined-record fields the search uses, labelled as NetSuite labels them, such as Time : Date. Starred fields come first: the dimensions, such as Subsidiary and Department, custom segments, and other list and date fields. Use the find box to narrow the list. If the list needs to load again, select Retry.
  3. Select Add > to move a field to Selected filters (in order). To add a field by its ID, select Add by ID… and enter it. For a field on a joined record, enter join.field, for example time.date.
  4. Optionally, rename each filter's Parameter name and verify the pre-filled Type and Operator. The In Excel: line shows the function as it will read in a cell. The function name itself can also be edited at the bottom of the dialog.
  5. Select OK to confirm your filter selection, then Save on the main preferences pane to apply your changes. Restart Excel to make the function changes available.

Selected filters in the Configure filters dialog, with the joined-record field Appliedtotransaction : Type

Each selected filter has the following settings:

ColumnDescription
FieldThe field's label, as NetSuite shows it. A joined field reads like Time : Date.
Parameter nameThe argument label shown in Excel for this filter. Give each filter its own name.
Field IDThe NetSuite search field the filter applies to, such as trandate, or join.field for a joined field, such as time.date.
TypeHow input values are interpreted: a list (Subsidiary, Item, Class, Department, Location, Entity, Transaction Type, Currency, or a custom segment), Date, Number, Text, Boolean, or Internal ID (no lookup). List types look names up in NetSuite. Basic types and Internal ID (no lookup) use the value as typed.
OperatorHow values are compared. List, Date, Boolean, and Internal ID (no lookup) filters set the operator automatically. Number filters offer operators such as Equal to, Less than, or Between; Text filters offer operators such as Is, Starts with, Contains, or Has keywords.

Arrange the filters with Move Up and Move Down, with Alt+Up and Alt+Down, or by dragging a row by its grip. Their order is the order of the function's arguments. To remove filters, select them and press Delete. When a filter still needs a parameter name or field ID, or shares its parameter name with another filter, the dialog highlights it and reads Fix the highlighted filters before saving. Select OK, then Save the preferences and restart Excel to apply your changes.

Once registered, see Using a Custom Saved Search Function to call your function from a cell.

Removing a Registered Function

  1. Under Registered Functions, select a function and choose Remove, then Confirm Remove. Remove All deregisters every function at once.
  2. Select Save and restart Excel. Removing a function also deletes its configured filters.

Tips and Tricks

  • Date filters create two parameters. A Date filter adds two date arguments to the function. Fill in the first to filter on that date, fill in both to filter the range between them (inclusive), or enter -1 as the first date to include everything since inception.
  • Between operators create two parameters. A Number filter using Between or Not Between adds two arguments, "(from)" and "(to)". Provide both. Like date ranges, the range is inclusive.
  • Add any field by its ID. To filter on a field the Available fields list doesn't show, select Add by ID… and enter the field ID NetSuite uses for that search filter, or join.field for a field on a joined record, such as time.date. Choose the field's data type, or choose Internal ID (no lookup) and pass NetSuite internal IDs directly.
  • Use Internal ID (no lookup) to pass internal IDs. For data types outside the provided types, or to pass values exactly as typed, select Internal ID (no lookup) and pass the NetSuite internal ID of the value.
  • Function parameter values override the search's own filters of the same type. If the saved search already includes a criterion on a field registered as a parameter, the value passed from Excel replaces that criterion for the run. The saved search itself stays as it is in NetSuite; only the Excel results change.
  • Leave an argument blank to skip that filter. A blank argument runs the search without that criterion, so one registered function serves both broad and narrow pulls.
  • Update formulas after renaming a function. After renaming and restarting Excel, update the formulas that call the old function name. Until then, they show #NAME?.