- Mark as New
- Bookmark
- Subscribe
- Permalink
- Email to a Friend
- Report Inappropriate Content
Need to find which Order is associated with the Invoice
Question:
I'm trying to generate a report on the orders that have been paid for and the ones that haven't.
- Invoice Item
- Order Item
"Subscription ID/Version" is the Key value for connecting both the data sources.
For eg. In "Invoice Item" data source, filter any Subscription with Invoice, take Subscription ID/Version values in the report. Then in "Order Item" data source, filter using the same Subscription Name. Along with that pull Subscription ID/Version, Order Number values in the report.
Once both reports are exported, we can use Subscription ID/Version to find out which Order is exactly matched to the Invoice.
Reference screenshots:
Order Item DS:
Invoice Item DS:
If you found my answer helpful, please give me a kudo ↑
Help others find answers faster by accepting my post as a solution √
I thought matching the order to an invoice item might be easiest but I can't seem to find any reliable link in the system that would allow me to match any of the Order metric objects to invoices.
Could you please help as this is blocking our reporting?
Answer: