I have a list of 290 POs that I need to enter as values in the "Created From" filter in a Saved Search. How can I enter all these 290 POs without having to manually write out each one.

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 enter a list of 290 POs in the "Created From" filter in a Saved Search, you can use a formula in the criteria. Here's how you can do it: 1. First, prepare your list of POs in Excel and create a formula to concatenate them into a format that can be used in a NetSuite formula. The formula in Excel would look something like this:

="'" & A2 & "',"

2. Copy the result of this formula for all your POs. It should give you a list like

'PO1','PO2','PO3',...

3. In your Saved Search in NetSuite, go to the Criteria tab and add a new criteria. Select "Formula (Text)" from the dropdown. 4. In the formula field, enter a formula like this:

CASE WHEN {createdfrom} IN (<paste your list here>) THEN 1 END

5. Set the operator to "is" and the value to 1. This will filter your search to only include records where the "Created From" field matches one of the POs in your list. Please note that this method has a limitation of 1000 characters for the formula field. If your list of POs exceeds this limit, you might need to split your search into multiple searches or find another workaround. Alternatively, if you have access to SuiteAnalytics, you can paste the list directly into the filter, regardless of the field type. This might be a simpler solution if you're dealing with large lists of values.