I'm trying to figure out how I can pull a report of Subscription Product Rate Plans that have a non-empty value for a custom field AND that subscription product rate plan has been removed from the subscription.
Solved! Go to Solution.
You can report on the RATE PLAN data source (product rate plans in the subscription). The trick is the filtering:
For filtering, you will need to add all of the custom fields, connect them using the OR condition, and set them as "IS NOT BLANK". Then connect these filters to Amendment: Type IS EQUAL TO 'Remove a Product'.
Your report should look similar to this:
Hopefully this works for you. If you need further assistance on this report, please feel free to open a support ticket so we can further investigate.
If you found my answer helpful, please give me a kudo ↑
Help others find answers faster by accepting my post as a solution √