I’m trying to create a transaction search that filters to the mainline, but also gets the department on the first line of the transaction. The transactions I’m showing normally only have a single line, so the ask from business is to just show the first line department. I realize I could filter to just a certain line using Line Seq, but then I lose access to certain fields on the mainline. Any tricks for this?

Use Main Line = either. Then DECODE to only get the Department from the line you want. Then Group/Summarise your other results columns.

Some mainline-level fields are accessible from the transaction lines too, such as

Account (Main)

and

Memo (Main)