what about revenue arragement's internalid using its tranid?

AI generated answer (using internal Slack threads):

In NetSuite, the internal ID of a Revenue Arrangement (RA) is not directly accessible from a Sales Order (SO) in a transaction saved search. However, you can use a formula to create a criterion that checks if the source of the revenue element is a Sales Order. Here's an example of such a formula:

CASE WHEN {revenueelement.source} LIKE 'Sales Order%' THEN 1 ELSE 0 END

In your results, you can use the ID (which is the id of your RA) and the following formula to see the Sales Order:

CASE WHEN {revenueelement.source} LIKE 'Sales Order%' THEN {revenueelement.source} END

Please note that the Revenue Arrangement's internal ID may not match the internal ID of the Sales Order. The Revenue Arrangement record has a Revenue Element sublist with a

Source

column, which contains a link to the Sales Order that generated the Element. The value stored in this field is an internal ID, but it doesn't match the internal ID of the Sales Order. The text displayed in the link is the correct Tran ID, but the internal ID may not match. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******