Auto Send A/R Statements

The Auto Send module is a convenient tool to e-mail or fax accounts receivable statements for customers. The user can choose between sending statements to all customers who have a balance due or only send statements to customers with overdue invoices. Continue with the following steps for details on configuring or sending a batch of statements to customers.

Statement Options

Complete the following steps to setup a Auto Send Mode.

  1.  Select File > Auto Send Options > Auto Send Modes from the main EBMS menu to open the following list:

  1. Click the New button to create a new Auto Send Mode and open the following dialog or select an Statements Auto Send Mode and click the Properties button. Continue with step 6 if the mode has already been created:

  1. Each Auto Send Mode requires a unique Key Id. This Key ID should be a simple descriptive code that does not include spaces or symbols.  

  2. Select the Statements Send Mode option as shown above.  

  3. Enter a short Description of the auto send mode type. This description should clearly describe the mode process. Note that this text is used as the EBMS menu label. Click OK to continue.

  4. Select File > Auto Send Options > Auto Send Modes > Auto Send Statements > Properties from the main EBMS menu as show below:

  5. Select the Show on Menu option to make this option appear on the main EBMS Sales menu.  This option should be disabled if the event is scheduled using the Task Scheduler App with the URL text described below.   

  6. Enable the Document will be printed if customer has no Auto E-mail/Fax entry option to print documents for customers without the settings required to email a statement.  Review the following Customer Configuration setting within Auto Send Sales Orders or Invoices for instructions on setting these options.   

  7. Maintain the default values within the Fields to Assign settings since they are advanced settings.    

  8. Select one of the following options to determine which customers receive statements:

    1. Select the Create Statements for all customer who have outstanding invoices option to send statements to all customers with outstanding invoices. A statement will not be send if the balance due is equal or below zero.

    2. Select the Create Statements for customers who have finance charge option to send statements only to customers with finance charges. This method uses the system’s finance charges to determine overdue charges.  If the finance charge amount on an invoice is greater than $0.00, it generates and sends a statement to this customer.  

    3. Select the Create Statements for customers who have invoices past the due invoices option to send statements to customers with past due invoices. This method uses the system’s finance charges to determine overdue charges.  If the overdue amount on an invoice is greater than $0.00, it generates and sends a statement to this customer.  

  9. Enter the appropriate Crystal report form into the Report Settings. This setting should reflect a standard Customer Statement report or an approved custom statement report. Many other reports may not execute properly within Auto Send. Contact your Eagle Business Software representative for more assistance.

  10. Minimum Report File Size: This feature is used to stop any sends on export files that are below a certain file size.

  11. The URL code can be copied to the Task Scheduler App to automate the sending process.   Review [Main] Technical > Automate using Task Scheduler App for instructions to send statements on a weekly or monthly basis.

  12. Click on the Contract Priorities tab to enter the recipient options.  Review Contact Priorities for configuration details on these important recipient settings.
  13. Click on the E-mail Settings tabs to configure the e-mail that will be sent to customers as shown below:
  14. Set an appropriate From Address. This setting will be reflected on the Statement E-mail's from value. Customer replies will be sent to this e-mail setting.
  15. Subject: Enter a brief subject for the E-mail such as the example shown above.
  16. Enter the e-mail’s Body Text (HTML) as shown above. Either use plain text or HTML for the body of the e-mail. Note that line break tags (<br>) may cause extra lines in the E-mail. Review the Test Mode section for details on testing the appearance of the e-mail.

Click OK to save settings.

Auto Send Statements to Customers

Accounts Receivable statements can be sent to customers a frequently as desired. Complete the follow steps to send statements:

  1. Review the Auto Send tab of a customer to add a Message or to exclude specific customers from the Auto Send batch.

  2. Select Sales > Update Finance Charges from the main EBMS menu to update the finance charges for overdue invoices. Review the Sales > Customer Finance Charges section for more details on this step.

  3. Launch the Auto Send process by selecting Sales >  Auto Send Statements from the main EBMS menu.

  4. Set the Auto Send Statement Date as shown below. This date will be used as the statement date.   
     
    Customers with balances due before or on this date will be handled. Statements will be created based on the option set in File > Auto Send Options > Auto Send Modes > AutoStatements > Properties dialog. The statement will be either E-mailed, faxed, or printed depending on the settings within the customer record.

  5.  Click on the OK button to continue process and click Cancel. Review the Test Mode section for details on testing the process.

The process will create a CSV log file if the logging option within the Auto Send Options > Diagnostic Settings is enabled as shown below:

The log file is found in the export folder set in General tab of File > Auto Send Options > General Options. The log file will be labeled Auto Statement Log and appended with the date of the statement process.