This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

When creating a scripted search in 2.0, can filter expressions contain formulas?

Theres a chrome extension called "Netsuite Saved Search Code Export"

If you can build the search in UI, you can get the code for free that uses that search

Very useful tool for generating these quickly, so if in the UI you use the formula, could probably produce the code

You have to save the search before it gives the code just a warning

Once its saved, just hit edit again then export as script in the top right

<@U01DHK58Q1G> Never would have expected this. Totally undocumented, but the format for formulas via an expression rather than a search.createfilter ---

["formulanumeric: CASE WHEN {x} in ('y') THEN 1 ELSE 0 END","equalto","1"]

This is why the plugin is amazing :slightly_smiling_face:

<https://suiteanswers.custhelp.com/app/answers/detail/a_id/51141/loc/en_US>

Just be very careful if you use string concatenation when creating the formula that can break Rhino

There is a beta version of the workbook export too. This will output the SuiteQL if you want to use a query.