Hi Everyone, I have created a saved search on the Bill Payment and I want to show the Invoice number(present on the Bill which is connected to the Bill Payment) in that saved search but I can't find it under any field. Kindly help me here to add the Vendor Invoice Number column in the results of this saved search!!! Below is the criteria I have applied:

Look at Applied To.. join

It is a Bill Payment which is created from Bill , the saved search is based on Bill Payment and Invoice Number is present on Bill and Applied To worked for related records but there is no related record for Bill Payment! please correct me if I'm wrong @michoel

Working for me

my criteria shared in above image

Oh sorry. Probably due to mainline filter

soo, now?🤔

Group by transaction

but I want to show every column on the same page, if I group then it won't show other columns

use a summary criteria like MAX on the other columns

I'm doing like you said but it still not working!