I can't seem to get the sublist field values for Revenue Elements sublist on a Revenue Arrangement search or dataset. I need to get those values so I can compare each line on the Revenue Arrangement with the matching line on the Source transaction, and update them to match.

Hey! Revenue Elements sublist isn’t queryable directly in searches, so use SuiteQL via REST API (POST /query/v1/suiteql) to join revenue_arrangement_line with transaction_line by document_number/line_id. Compare and update via script.

Thanks! I'll remember that for next time -- I got it to work via a saved Revenue Elements search joining to the Source Transaction and Revenue Arrangement.