NS_CONCAT({item}) update the formula to give the unique items only in summary Saveved search Maximum

AI generated answer (using internal Slack threads):

In NetSuite Saved Search, the

MAX

function in formulas works in conjunction with the

GROUP BY

statement. If there is no group by,

MAX(any_column)

will return the largest value for that column across all records returned by the search criteria. If you want to create a saved search that shows the last date sold for each item, you can do a main line = false transaction saved search and group by item then use

MAX

on the transaction date. However, if you want to use

NS_CONCAT({item})

and update the formula to give the unique items only in a summary saved search, you might need to use a different approach.

NS_CONCAT

is a function that concatenates all values of the field for a group in a saved search. Unfortunately, there is no direct way to get unique values only using

NS_CONCAT

. You might need to use a workaround such as creating a custom field that stores unique values and then use

NS_CONCAT

on that field. Remember to break down the formula into its constituent parts and display them separately to ensure everything is working as expected. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******