Need to find which Order is associated with the Invoice
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.
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 √