How to show text for a search value that returns the internal Id
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 1029, and the users would like to see Invoice #00001. Is there a way to use a text formula to replace this value?
Might need a bit more information, but would using Document Number solve this?