Happy Business Starts Here

Advanced Tutor

report on custom field on rate plan that has been removed from subscription

Hello,

 

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.

 

Possible?

1 REPLY 1
Highlighted
Support SME

Re: report on custom field on rate plan that has been removed from subscription

 

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:

 

Zuora 2018-02-01 at 11.41.11 AM.png

 

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 √