Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
Use Formula to Reference Multiple Item Lines in 1 results row
I may be on the edge of crazy to even ask such a thing, but I have a scenario where I'm exporting Invoices into a 3rd party application that simply needs Item IDs (SKUs) listed in-line within a single text field. I can deliver the NetSuite data to the application using a Saved Search, but as we know, Saved Searches of Invoices will divide each Item into its own row.
Here's an example of the data as it is now:
I'm wondering if there's a way for me to "roll up" or concatenate the Item data into 1 row that reads something like "40.000004 || Delivery" (where || could be any delimiter).