in analytics workbook, how can i create formula field that lists all applied invoices - previous separated by comma?

AI generated answer (using internal Slack threads):

****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ****** In NetSuite's Analytics Workbook, creating a formula field that lists all applied invoices separated by commas is not directly supported. The workbook is designed to work with structured data and does not support the creation of dynamic lists within a single field. However, you can create a saved search to achieve a similar result. Here's a general approach: 1. Create a Transaction Saved Search. 2. Set the criteria to

Type = Invoice

. 3. In the Results tab, add the fields you need for your report. You might want to include

Document Number

and

Created From

to link the invoice to the original sales order. This will give you a list of all invoices, which you can then export and manipulate in a tool like Excel to create a comma-separated list. Remember, this is a workaround and might not be suitable for all use cases. If you need a more dynamic solution, you might need to consider a custom SuiteScript solution.