Hi team,
I can run a revenue elements saved search by source transaction type = Cash Sale or Sales Order. On the revenue element record this is represented in the Source line field. Some of our revenue elements are created from Subscriptions. I want to create a saved search search that only shows revenue elements from Subscriptions. Any tips? I have tried almost all the field options on the saved search Type = Revenue Element to no avail.
I noticed that only subscription based revenue elements have a value for the Subscription Line so I tried to add this criteria as None of -None- but this brings no results.
I also tried unsuccessfully using formula test and field ID's from: https://system.netsuite.com/help/helpcenter/en_US/srbrowser/Browser2017_1/odbc/record/revenue_elements.html
i.e source_transaction_id, source_type and source_id are all rejected as invalid field names.
No point showing the saved search screenshots as there is no criteria apart from this criteria I've been trying to set across different fields and field ID's. Below are some other screenshots:
Revenue Arrangement (Subscription):
Revenue Arrangement (Sales Order):
Revenue Elements (Subscription):
Revenue Elements (Sales Order):