Marc
05/05/2025, 10:50 AMCeligo AI
05/05/2025, 10:50 AMAI generated answer (using internal Slack threads):To add the "amount" field to the filters of a saved search in NetSuite, you can use a workaround by adding a Formula (text) criteria. Here are the steps: 1. Go to your saved search and navigate to the Criteria tab. 2. Click on the 'Add' button next to 'Formula (Text)'. 3. In the formula field, you can use a formula like
TO_CHAR({amount})
to convert the amount field to text.
4. Set the operator to 'contains'.
5. Leave the value field empty. This will allow you to enter a value when you run the search.
6. Save the search.
Now, when you run the search, you should see a new filter field where you can enter an amount to filter by.
Please note that this is a workaround and might not be perfect. Another solution might be to use a Dashboard 'Search Form' which works from the criteria from the Results columns instead in Criteria.
******
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:50 AMSlack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.868242085
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.837414682
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.834340513
Celigo AI
05/05/2025, 10:50 AM