formula to display the item and the amount in the same row in a summary transaction saved search

AI generated answer (using internal Slack threads):

To display the item and the amount in the same row in a summary transaction saved search, you can use the following steps: 1. Create a new Transaction Saved Search. 2. In the Criteria tab, add the necessary filters for your search. 3. In the Results tab, add the 'Item' field and set the Summary Type to 'Group'. This will group all the transactions based on the item. 4. Add another field, 'Amount', and set the Summary Type to 'Sum'. This will sum up all the amounts for each item. 5. If you want to display the item and the amount in the same column, you can create a Formula (Text) field with the following formula:

{item} || ' - ' || TO_CHAR(SUM({amount}))

. This will concatenate the item and the amount, separated by a hyphen. Set the Summary Type for this field to 'Group'. Please note that the formula might need to be adjusted based on your specific requirements and the actual field names in your NetSuite account. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******