I created a transaction search which appears to return each line item on a sales order. is there a way to get the sales order today in that same search? I don't see any columns that might contain that which look obvious

You'll have to ask that again - cause I'm confused

I'd like to show a search result that has the SO #, the customer information, the sales rep, the date and the total amount of the SO#. I built a transaction search that gives me this but it contains multiple lines if the SO has multiple items. Is there a way in the search to get the SO total, and perhaps avoid the multiple lines.

you have to add as criteria "main line" is true