2. Emailing Reports

If an xTuple ERP report window has a SCHEDULE button on it, that means the report can be sent to the xTuple Connect Batch Manager for processing. Reports can either be sent directly to a printer or a .PDF version can be emailed. For this example, we will be emailing a copy of an A/R Aging report.

First, we need to run the report. To get to that screen, follow these steps:

  1. Follow this path: Accounting > Accounts Receivable > Reports > Aging

  2. Simply use the default values

  3. Select the QUERY button

  4. The following screen will appear:

    AR Aging Report

As you can see, the A/R Aging report screen has a SCHEDULE button. To send this report to the xTuple Connect Batch Manager for email processing, follow these steps:

  1. Select the SCHEDULE button

  2. The xTuple Connect Batch Manager submission screen will appear

  3. Leave the scheduled date as ASAP (As Soon As Possible)

  4. The email address of the user who submitted the report will appear in both email fields

  5. To send the report to another person, simply enter additional email addresses in the "Response Email To" field, separated by commas

  6. Type in a message in the "Response Body" field even if you are sending the report to yourself since some spam filters reject email that has no message content

  7. The following screen shows a sample submission:

    Submitting AR Aging Report to xTuple Connect Batch Manager

When you select the SCHEDULE button, the report will be sent to the xTuple Connect Batch Manager for processing. In the following screen, we see an example email with the A/R Aging report attached in .PDF format:

Email with AR Aging Report Attached

Finally, the following screenshot shows what the attached file looks like when the .PDF is opened:

Sample .PDF of AR Aging Report

Note

The Submit Report to xTuple Connect window lets you choose to send the report directly to a printer instead of sending it by email. The printer used is the default printer on the computer running the xTuple Connect Batch Manager client.

Warning

Some very old report definitions use legacy parameter values (e.g. %1 or %2). These reports will not print successfully through the Batch Manager. If this problem is found, update the report definitions to use named parameters (e.g. <? value('invchead_id') ?>).