Marc
05/05/2025, 10:54 AMCeligo AI
05/05/2025, 10:54 AMAI generated answer (using internal Slack threads):To add the "amount" field to the filters of a saved search (not in criteria but in Available filters), you can use a workaround by adding a Formula (text) criteria. Here are the steps: 1. In your saved search, go to the Criteria tab. 2. Add a new criteria, select Formula (Text) from the dropdown. 3. In the formula field, you can use a nominal amount for the default search, for example,
100
.
4. Then, go to the Available Filters subtab and add the Formula (Text) field.
This way, you can enter a value directly in the filter instead of filtering through the column header dropdown.
Another solution might be to use a Dashboard 'Search Form' which works from the criteria from the Results columns instead in Criteria.
Please note that this is a workaround and might not be perfect for all scenarios.
For more detailed information, you can refer to this article: [Using NetSuite Saved Search Formulas as Filters](https://www.sikich.com/insight/using-formula-values-as-available-filters-in-netsuite-saved-searches/)
******
Disclaimer:
This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes.
******Celigo AI
05/05/2025, 10:54 AMSlack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.874852479
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.840588152
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.84035182
Celigo AI
05/05/2025, 10:54 AM