@All, I have saved search on Payment record applied on invoices. I want all the rows from invoices with this payment record. When I execute the search I am getting single record of payment. How can I get all the records from invoice where the invoice record contains multiple lines in it. Thanks in advance.

@vilaspadole in the criteria invoice main line should be set to false

i dont think that relationship exists. a payment record is related to the mainline of its invoice, not the line items of the invoice.