Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and 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).
0