How to exclude reversed and written off invoices from reporting
I want to report on all invoices but exclude those that are reversed or written off.
Using the "Invoices" data source, excluding reversed invoices is easy because there's a "reversed" flag I can use.
However, I can't see how to exclude written off invoices (of which we have thousands because we're still migrated into the system).
I also looked at the credit memo data source as you can view the reason code from the credit memo (to see credit memos created due to a write-off), however, that ONLY shows invoices with a credit memo applied.
My best effort right now is to run 2 reports - one showing all invoices and the other invoices with a credit memo applied and then use excel to filter out the ones with credit memos from the full list. But that feels like a pretty horrible solution.
Am I missing something?