- Mark as New
- Bookmark
- Subscribe
- Permalink
- Email to a Friend
- Report Inappropriate Content
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 √
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Email to a Friend
- Report Inappropriate Content
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)
If you found my answer helpful, please give me a kudo ↑
Help others find answers faster by accepting my post as a solution √
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Email to a Friend
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Email to a Friend
- Report Inappropriate Content
Re: How to find all latest charges of active subscriptions
If using data source export, as it cannot set filters with OR, so need use the following steps:
If you found my answer helpful, please give me a kudo ↑
Help others find answers faster by accepting my post as a solution √