Is there a way to show the revenue arrangement internal id in a transaction saved search with type of sales order as a criterion? It looks like I can only access it via the revenue elements joins which does not expose the internal id

The source transaction of your RA is your SO ? Use criteria formula numeric : CASE WHEN {revenueelement.source} LIKE 'Sales Order%' THEN 1 ELSE 0 END In your result use ID ( id of your RA) and CASE WHEN {revenueelement.source} LIKE 'Sales Order%' THEN {revenueelement.source} END to see the sales order

But it's the other way around. From SO to RA