Happy Business Starts Here

Zuora Alumni

I Need A Usage Against Invoice Report

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.



If you found my answer helpful, please give me a kudo ↑
Help others find answers faster by accepting my post as a solution √

2 REPLIES 2
Zuora Alumni

Re: I Need A Usage Against Invoice Report

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



If you found my answer helpful, please give me a kudo ↑
Help others find answers faster by accepting my post as a solution √

Valued Scholar

Re: I Need A Usage Against Invoice Report

@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