Hi all, we're creating a saved search for POs that includes the paired intercompany transaction field. However, when pulling this field into the search results, it returns the internal ID of the transaction rather than a transaction number. Also, it's not a related field where I can drill into it to get the document number myself. Has anyone dealt with this problem before?

Try using a formula instead. Might be able to reach what you’re looking for.

I tried using a text formula and just have it return the field {intercotransaction} but unfortunately it's the same result. Unless there's some equivalent to the SuiteScript "getText" that's available in a search I'm not aware of

Try {intercotransaction.fieldname} and replace field name with the field you want

Good suggestion but it's not allowing me to do that because it's not a related field, so it doesn't recognize the join. Even if I try {intercotransaction.internalid} I'm getting a field not found error

Do you get anything when you do {intercotransaction.id}?

Oddly enough, that does work. However, the intercotransaction is a sales order that has a field called 'tranid', but when I try to pull that one in, it's telling me it doesn't exist

Maybe try other fields to see if those pull in

Unfortunately it's not pulling in any other fields from the SO

What type of formula are you using?

have you tried doing the same in analytics? paired ic transaction is there, {intercotransaction}, also {intercotransaction^trransaction.intercotransaction}