How do I show multiple line items on a single line of a saved search for transactions?

This would be useful for nearly any transaction, but I’m specifically looking at SALES ORDER.

What I’d like to do is show the Sales Order Number (Document Number) followed by all the items that are on that order in another field, either separated by commas or line breaks.


SO123  |  ItemXYZ, Item YZZ

SO124  |  ItemZYY, Item XZZ, ItemABC, ItemZZZ

I am not sure if this can even be done. Any help would be greatly appreciated!

Rookie Asked on January 12, 2022 in Saved Searches.
Add Comment
4 Answer(s)

I doubt you can do this in saved search, only option is mainline T or F.  You can explore the suiteanalytics workbook, might be able to do this.

Advanced Answered on January 12, 2022.
Add Comment

You can use NS_CONCAT with a summary search.  E.g:

Field                                                                             Summary Type

  • Document Number                                                       Group
  • Formula (Text)                                                                Maximum
    • Formula: NS_CONCAT({item})
Beginner Answered on January 27, 2022.
Add Comment

Replace(ns_concat({item}), ‘,’ , ‘<br>’)

Replace(ns_concat(NVL({quantity},0)), ‘,’ , ‘<br>’)

Replace(NS_CONCAT(TO_CHAR({quantity}-nvl({quantitycommitted},0)-nvl({quantityshiprecv},0))), ‘,’ , ‘<br>’)



Rookie Answered on April 28, 2022.
Add Comment

To add a space between items: REPLACE(NS_CONCAT({item}), ‘,’, ‘, ‘)

Rookie Answered on March 27, 2023.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Become a Sponsor   Become a Sponsor