NS_CONCAT({item}) update this to give the items and remove duplicate

AI generated answer (using internal Slack threads):

To update

NS_CONCAT({item})

to give the items and remove duplicates, you can use a Summary Saved Search in NetSuite. Here's how you can do it: 1. Create a new Saved Search of the type that matches your data (e.g., Item Receipt). 2. In the Results tab, add the fields you want to display. For the field you want to concatenate and remove duplicates (e.g., item), you should use a Formula (Text) field. 3. In the Formula (Text) field, manually type

NS_CONCAT({item})

in the formula box. This function is not officially supported and won't appear in the dropdown, but it can be manually typed in. 4. In the Summary Type dropdown for the Formula (Text) field, select Group. 5. In the Criteria tab, add any necessary filters to your search. 6. Save and run the search. This will group your results by the item field, concatenating the values into a single line and removing duplicates. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******