I Need A Usage Against Invoice Report

[Kalpesh]

Question or Problem Statement:

I need a Usage against Invoice report, however, from the Data Source, there is no direct connection between Usage and Invoice.

[Kalpesh · Accepted solution]

Solution:

1. Export Usage with Usage Id and Subscription Id.
2. Export Invoice Item with Subscription Id and Invoice Number.
3. Merge the above 2 reports using Subscription Id field

Note: If there are multiple amendments in a subscription, the subscription Id for the usages might be null. You will need to find the Original subscription Id.

Supporting References:
https://knowledgecenter.zuora.com/CD_Reporting/Data_Exports/Z_Data_Source_Reference

[bsanders]

@Kalpesh

This does not work in the event that multiple invoices are billing usage against the same SubscriptionID. For Example a 12 month Base fee with monthly usage charges. In this event the SubscriptionID will be the same across all Usage Records which will not allow us to allocate the usage records according to which invoice they were billed against.

This can be done however by pulling an extract based on the Processed Usage object which includes the Invoice, Invoice Item, and Usage objects