====How To Make Sales Reports Run Automatically====

There are a couple of ways actually:

1. Make a copy of the script MailSalesReport.php sale call it MailMySalesReport.php - the top part of this script has some user modifiable parameters - which are documented in the file as below:

##php
The intention is that this script is called from cron at intervals defined with a command like:

/usr/bin/wget http://localhost/web-erp/MailSalesReport.php

The configuration of this script requires the id of the sales analysis report to send
and an array of the receipients */

/*The following three variables need to be modified for the report - the company database to use and the receipients */
/*The Sales report to send */
$_GET['ReportID'] = 2;
/*The company database to use */
/usr/bin/wget http://localhost/web-erp/MailSalesReport.php

$DatabaseName = 'weberp';
/*The people to receive the emailed report */
$Recipients = array('"Root" <root@localhost>','"' . _('someone else') . '" <someoneelese@sowhere.com>');

##

Now you need to set up a scheduled job using either cron if your web-host is a linux or unix machine (as 70+% are) or windows scheduler. To call the page you need to use the wget utlity program - the command to put into cron using your web-hosts cpanel or whatever utility they provide for scheduling jobs is:


/usr/bin/wget http://localhost/web-erp/MailMySalesReport.php

====Method 2:====

Use the report_runner.php script

this script takes a number of parameters

 ~ -r reportnumber (the number of the weberp report)
 ~ -n reportname   (the name you want to give the report)
 ~ -e emailaddress[;emailaddress;emailaddres...] (who you want to send it to)
 ~ -d database name (the mysql db to use for the data for the report)
 ~ [-t reporttext ]  (some words you want to send with the report-optional)
 ~ [ -H weberpHOME]  (the home directory for weberp - or edit the php file)

If you wanted to email report number 5 and call it MyReport to joe@mycompany.com and fred@mycompany.com and my database is weberpdemo then you would enter the command:

path_to_webERP_install/report_runner.php -r5 -nMyReport -ejoe@mycompany.com;fred@mycompany.com -dweberpdemo -t"Please find attached MyReport"