how to show a non store value field in a saved search using SQL formula

AI generated answer (using internal Slack threads):

To show a non-stored value field in a saved search using SQL formula, you can create a custom field with 'Store Value' unchecked and a formula used to dynamically calculate the field value. This field can then be pulled into search results with the result still calculating correctly. Here is an example of how you might create such a formula field: 1. Navigate to the custom field creation page (for example, for an item field, go to Customization > Lists, Records, & Fields > Item Fields > New). 2. Fill in the necessary details for your custom field, such as the label and ID. 3. In the 'Store Value' section, make sure to uncheck the box. 4. In the 'Formula' section, input your SQL formula. 5. Save the custom field. Now, when you create a saved search, you should be able to include this custom field in your results. The value of this field will be calculated dynamically based on the formula you provided. Please note that this feature may not have been available in older versions of NetSuite, but it has been supported for a few years now. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******