RE: 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!
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
