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
For the invoice items data source, be sure to pull in the charge number as that is what you'll use for the vlookup.
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 √