Hi guys, I’m trying to create a saved search to show paired intercompany transactions. The field in the search returns the internal id of the paired transaction, but the users would like to see the text as it would appear on the transaction form. For example the search returns 123456, and the users would like to see Sales Order #123. Is there a way to use a text formula to replace this value? Thanks for your time 😊

Can you share your search looks like