Happy Business Starts Here

How to exclude reversed and written off invoices from reporting

Valued Scholar

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

 

Any ideas?

 

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?