Happy Business Starts Here

Highlighted
Zuora Support

How to find all latest charges of active subscriptions

How do I build a report on latest / active charges of all active subscriptions in my tenant?



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

2 REPLIES 2
Zuora Support

Re: How to find all latest charges of active subscriptions

You can use our Reporting tool to build a report on Rate Plan Charge object with the following filters.

 

  • Subscription: Status = Active
  • AND Rate Plan Charge: Is Last Segment = True
  • AND (Amendment.Type = Remove a Product OR Amendment.Id = Null)

Filters



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

Senior Tutor

Re: How to find all latest charges of active subscriptions

This gave me exactly what I needed, but I think there is a typo in your answer. Your third bullet says

  • AND (Amendment.Type = Remove a Product OR Amendment.Id = Null)

but I believe it should be not equal to Remove a Product:

  • AND (Amendment.Type != Remove a Product OR Amendment.Id = Null)

 

That would match the logic you show in your screenshot of the Reporting tool, and also makes more sense intuitively.