- Mark as New
- Bookmark
- Subscribe
- Permalink
- Email to a Friend
- Report Inappropriate Content
Question: How to generate the discount report for both subscription and Rate Plan level
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.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Email to a Friend
- Report Inappropriate Content
Response:
1. Create a custom report by using Column report type and RatePlanChargeTier datasource from Data Source Tab, Z~Reporting Internal Use section.
2. Select fields such as
- Product: Name
- Rate Plan: Name
- Rate Plan Charge: Name
- Rate Plan Charge: Charge Number
- Rate Plan Charge: Charge Model
- Rate Plan Charge: Discount Level
- Rate Plan Charge Tier: Discount Amount
- Rate Plan Charge Tier: Discount Percentage.
- Set filters:
- Subscription.Status (=) Active
- RatePlanCharge.IsLastSegment (=) true
- RatePlan.AmendmentType Is Not Equal RemoveProduct
- RatePlanCharge.ChargeModel Begins With Discount
- Create Sorting Column:
- Subscription.Name AscendingGeneral Show Hide
3. Save the report and run.
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
Response:
1. Create a custom report by using Column report type and RatePlanChargeTier datasource from Data Source Tab, Z~Reporting Internal Use section.
2. Select fields such as
- Product: Name
- Rate Plan: Name
- Rate Plan Charge: Name
- Rate Plan Charge: Charge Number
- Rate Plan Charge: Charge Model
- Rate Plan Charge: Discount Level
- Rate Plan Charge Tier: Discount Amount
- Rate Plan Charge Tier: Discount Percentage.
- Set filters:
- Subscription.Status (=) Active
- RatePlanCharge.IsLastSegment (=) true
- RatePlan.AmendmentType Is Not Equal RemoveProduct
- RatePlanCharge.ChargeModel Begins With Discount
- Create Sorting Column:
- Subscription.Name AscendingGeneral Show Hide
3. Save the report and run.
If you found my answer helpful, please give me a kudo ↑
Help others find answers faster by accepting my post as a solution √