Hi all, I’m creating a saved search on Transaction records. On the transaction, I have a custom field called “Created From”, which stores the source transaction for a PS invoice it was created from. The issue is: Whenever I join this custom field to fetch body-level fields from the source transaction, my results show multiple lines, even though “Main Line = true” for my transaction search. Is this behavior normal? Because when I do the join using the standard “Created From” field, this issue does not occur.

I wonder if this is built in functionality on standard "Created From" to avoid joining on all lines. Have you tried doing the mainline=true on both the source transaction and the joined transaction?

I'm guessing this is because a lot of the standard Created From joins are actually at the line level even though it kind of implies a bit that they're at a header level. Can't be multiple lines if the join is one to one, line to line. If your custom Created From is completely at a header level, I agree that trying Created From (custom) : Main Line=TRUE along with Main Line=TRUE on your main search node has a pretty good shot of fixing your problem.

@eblackey @RJMNS i did, but wanted to know is this normal or not. haven't seen this before

yes I'd say that's normal @wishalsangole4444 since you're doing a one to many join in that scenario