Running a report based on renewal amendments

[Rolando]

I created a report and tried to pull out all the amendments that labeled as “Renewal” in Amendment Type field. We have quite a few this kind of amendments, but the report is grabbing any of them. Could you please take a look at the report setting, and let me know what was the problem?

[Rolando · Accepted solution]

Unfortuanately you cannot use the Amendment: Type field to run the report based on 'Renewal'.

The amendment relationship tracks the last product amendment to impact a particular rate plan. 'Renewal' is a non-product amendment, which are only tracked in the Subscription Version Amendment relationship. This will give the amendment that created a given subscription version.

To report on the Subscription Version Amendment field you can use either Subscription or Rate Plan data source.

Example of basic report to report on renewals:

[sub_future]

We want TCV and Amendment Type in same report... as TCV is in RatePlan Charge Level and to get amendment version type we have run report on Rate Plan level. Let us know how we can get both in same report ?