how to get the transaction id of paired intercompany transaction in saved search results

AI generated answer (using internal Slack threads):

To get the transaction id of the paired intercompany transaction in saved search results, you can try using a formula field. However, it seems that the field {intercotransaction} only returns the internal ID of the transaction and not the transaction number. Unfortunately, it appears that the field {intercotransaction} is not a related field, so you can't use a join to get the document number. Also, it seems that using {intercotransaction.fieldname} doesn't work because it's not a related field, so it doesn't recognize the join. One user suggested using {intercotransaction.id}, which seems to work, but it doesn't pull in any other fields from the sales order. Another user suggested trying to do the same in analytics, using {intercotransaction} and {intercotransaction^trransaction.intercotransaction}, but it's not clear if this worked. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******

You cant get the actual document number/transaction ID of a linked intercompany transaction in a saved search. We needed this and had to script it.