Missing Email for Monthly Statements

afranza1
New Contributor II

I know when you send statements via email from AR Management you get a list of customers with missing emails. This list only appears just before you send the emailIs and isn't printable. Is there a way to generate a report filtering customers with balances and missing email invoice email contacts?

2 REPLIES 2

afranza1
New Contributor II

I did what you suggested and I made a report that almost gives me everything I want. I had to use the "Email Sent" field which applies only to invoices. Unfortunately, you can email an invoice without the check Email Invoice & Statement check box selected in the customer file. 

iwarren39
New Contributor III

I'm sure you could go into more detail with what you need in the columns but this is what I came up with. Create a report under 'customer' and 'invoices'. Select the columns customer name, customer email, and balance. Make sure you filter balance by 'is not equal to 0' and customer email by 'is empty' This should give you what you need. Hope this helps!