This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

what saved search formula will list all applied transactions in one column separated by commas?

&gt;*AI generated answer (using internal Slack threads):*
To list all applied transactions in one column separated by commas in a saved search, you can use the following formula:

```SQL
GROUP_CONCAT({appliedtotransaction} SEPARATOR ', ')
```

This formula will concatenate all the applied transactions into one string, separated by commas. Please note that this formula is based on MySQL syntax, which is used in NetSuite saved searches.

However, it's important to note that NetSuite does not natively support the GROUP_CONCAT function. You may need to create a custom field that concatenates the values you need, and then use this field in your saved search.

******
Disclaimer:

This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes.
******

&gt;*Slack thread 1:* <https://netsuiteprofessionals.slack.com/archives/C298P0BCK/p1572461500046100|here> (available only if the original thread was posted in the last 90 days)
&gt;*Similarity score:* 0.84647876

&gt;*Slack thread 2:* <https://netsuiteprofessionals.slack.com/archives/C298P0BCK/p1705663489455749|here> (available only if the original thread was posted in the last 90 days)
&gt;*Similarity score:* 0.842298508

&gt;*Slack thread 3:* <https://netsuiteprofessionals.slack.com/archives/C298P0BCK/p1620167151469700|here> (available only if the original thread was posted in the last 90 days)
&gt;*Similarity score:* 0.838738859



Please provide your feedback on this answer.