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.
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