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: