Hello!
I'm working on defining our process for Event Cancellations. Is there a report that will list Unpaid Invoices by Performance? Unfortunately, using the Invoice payment method places the order in a "Paid" status, as far as reports are concerned. I could have sworn I had found something in the past, but the best I can find now is Payments by Performance (which will show if the Invoice payment method was used), and then manually combing the Invoice Detail Report to cross check it with the Order Export report. Is there a better way?
This would be very useful to pull into Analytics. Let me know if you find a simpler answer!One thought would be to have the 'Invoice Detail' report scheduled to run daily (looking only at 'Due' Invoices), and manually import that into a list daily. Then you could have a widget filtered by that list (looking at orders only with the 'Invoice' Payment Method).
I'm not sure if this is a better or worse system than what you've got! Would that help to connect the dots?