- Mark as New
- Bookmark
- Subscribe
- Permalink
- Email to a Friend
- Report Inappropriate Content
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 √
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Email to a Friend
- Report Inappropriate Content
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 √
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Email to a Friend
- Report Inappropriate Content
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 √
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Email to a Friend
- Report Inappropriate Content
Re: I Need A Usage Against Invoice Report
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