what's the best way to get a calculated field that isn't a stored value into a saved search?

AI generated answer (using internal Slack threads):

****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ****** To get a calculated field that isn't a stored value into a saved search in NetSuite, you have a few options: 1. SuiteScript or Workflow: You can move the calculations to a SuiteScript or Workflow so the fields can actually save those values. This is a common approach when the calculated field gets its result from a saved search. 2. Secondary Field: Another approach is to create a secondary field and use a scheduled workflow to push the values in. This is similar to scripting but might be a bit more time-consuming. 3. Formula Field: If the calculated field is a simple formula, you can recreate it in a formula field in the saved search. For example, a formula field like

FLOOR(NVL({paymentdate},{today})-{invoicedate})

might be enough. Make the summary type of the field = average; show totals for the saved search. 4. Non-stored Fields in Saved Search: As per recent updates, it seems that NetSuite now allows non-stored fields to be available in saved searches. This means that a custom field with 'store value' unchecked and a formula used to dynamically calculate the field value can be pulled into search results with the result still calculating correctly. However, this might not be a permanent feature and could be subject to changes in future updates. Remember to test these methods thoroughly to ensure they work as expected in your specific use case.