I have a transaction search filtered to “Return Authorization” types. I want to include the corresponding item receipt internal id as a results column.

I accomplished this by including a formula(numeric) field for {applyingtransaction.id}, but that duplicates results because it can bring back both the Item Receipt and the Cash Refund.

I thought I could fix this by adding a criteria of Applying Transaction : Type = Item Receipt, but then that excludes any non-received returns.

Is there some other way I can pull in the item receipt id while preventing duplicate results?