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.
Example:
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!
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.
You can use NS_CONCAT with a summary search. E.g:
Field Summary Type
- Document Number Group
- Formula (Text) Maximum
- Formula: NS_CONCAT({item})
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>’)
enjoy
