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

<@UE3DBP8JC> you can create a custom field based on a summary saved search and concatenate the values using `LISTAGG` or `NS_CONCAT.`

So I'd still need to group by sales order then? And also have a result with the concatenated values?

<https://system.netsuite.com/app/help/helpcenter.nl?fid=section_3746191995.html>

You wouldn't actually group it, just set the available filter to the transaction as per linked documentation

I've used these before and I thought I had to use summary results. Maybe I've been missing something though ha

You would need summary results just not a _grouped_ column. Just a single Formula (Text) column with summary type MAX and formula `LISTAGG({class})` will probably do the trick

Ah right right. And then I will store this value with workflow in a second field! Thanks

Yup if you want this to be a stored field