I'm trying to create a transaction saved search with the following Criteria and Results. My goal is to show the IF and Invoice per SO line in one row only. However, the related SO status and invoice status are being shown as multiple lines in one row. There are only two invoices, so only two statuses must show up. Three IFs, so 3 statuses only.

my guess is that you have multiple joins in your columns

Yeah, billing and applying through formulas. I was hoping to get rid of it by using formulas.

what if the record has 2 fulfillments per one SO

@Rob Cady not really. Look at the statuses. They are shown multiple times.

I would try by removing the Item joins. See if that gets a better result. I don’t understand which are the “packed” status and to which IF they relate.

When I was using only the IF join, it was working perfectly. I'll try to play around more.