Is there a creative way to get the bill payment from a transaction saved search of bill when Main Line is F?

Have you tried Main Line = Either/Both?

I need to exclude the main line and retain the transaction lines only.

@Luis play with the Line numbers of the transaction line. Using Main Line - Either the Bill Payment info will be on Line 0 which you can exclude from your other columns.

I don't that would work. I need to show the bill payments at the transaction line level and not at the main level. So all line sequence numbers greater than 0 must have that Bill Payment (not just the 0).

OK, got you. I feel it can be done with an SQL statement. Here's one shot: MAX /* comment */ ({payingtransaction}) OVER(ORDER BY {internalid} ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW). Needs work though to replace the "unbounded" but hopefully this gets you on the right track

It's working. Amazing! Thank you so much!