Happy Business Starts Here

Student

Relationship between usage record and invoice

How can we find the invoice id for a given usage record? 

3 REPLIES 3
Tutor

Re: Relationship between usage record and invoice

You would have to run two data reports or datasources, export to excel, and do a vlookup against the two.

 

The two data sources:

 

a. Invoice Items

b. Usage

 

For the invoice items data source, be sure to pull in the charge number as that is what you'll use for the vlookup.

-
Student

Re: Relationship between usage record and invoice

SubscriptionId will not be required?

Zuora Support Moderator

Re: Relationship between usage record and invoice

@prad - you won't need the subscriptionID because the charge number is a unique value associated with that specific rate plan charge which is associated only with that subscription.



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