Happy Business Starts Here

Highlighted
Zuora Support Moderator

Suspended Account report

 

Trying to set up a report showing what accounts were suspended & dollar amounts for a specific month.

 

We would like to know the total dollar amount of subscriptions that are suspended for a particular month. IE - if we've suspended 5 subscriptions for the month of Sept & each sub is $100. I'd like to see the account name & amount of $100 for Sept.

 

We are using Suspend Amendments for this.





SigNowBlue.png

 


If you found my answer helpful, please give me a kudo ↑
Help others find answers faster by accepting my post as a solution √

1 REPLY 1
Zuora Support Moderator

Re: Suspended Account report

This report is a little more tricky because in order to pull the exact month when the suspension amendment was created we need to use a specific data source that can only pull in the Account's contracted monthly recurring revenue (CMRR).

 

With that said, below please see an example of how you can start building this report using the RATE PLAN data source.

 

The Rate Plan data source contains the "Subscription Version Amendment" object which can report on the SPECIFIC version of a subscription- which in this case we only want to know about the Suspended version of the subscription.

 

Zuora 2017-09-08 at 12.37.12 PM-222.png





SigNowBlue.png

 


If you found my answer helpful, please give me a kudo ↑
Help others find answers faster by accepting my post as a solution √