Is there a report that shows clients that are setup for email delivery of invoices and customer statements?

Under the AR module, Customer Maintenance, Maintain Customers, doc transmittal you can elect to have invoices, credit memos, debit memos, customer statements, etc. setup for hard copy or email delivery.  We're trying to get the majority of our clients setup with email delivery using PDF, so we're making sure to check the appropriate boxes in doc transmittal.  In short, if we have a valid client email address on file, I want to make sure that email delivery is turned on for them.

Is there a report I can run that shows me which clients are setup for email delivery?

Parents
  • If you don't have a Crystal Report License which you would need to purchase if you don't have one you would not be able to use the Crystal report method.

    You could have your DBA or an individual that has permission to run queries on the Sql Server they can run the query below and export the results to an Excel file for you.

    As Ramon Mentioned you can add the Where clause he suggested to limit to Customers that don't have the Doc Transmittal set up.

    Kevin

Reply
  • If you don't have a Crystal Report License which you would need to purchase if you don't have one you would not be able to use the Crystal report method.

    You could have your DBA or an individual that has permission to run queries on the Sql Server they can run the query below and export the results to an Excel file for you.

    As Ramon Mentioned you can add the Where clause he suggested to limit to Customers that don't have the Doc Transmittal set up.

    Kevin

Children
No Data