Here is my need - to schedule the delivery of a stock X3 report via email that is not triggered by an event (so workflow is really  not an option).  The main problem is the report has a script that runs first to populate a temp table.   If it were not for the script - I could create this event in Sage Workflow and Alerts.

I can think of maybe two ways to do this.1) Create a recurring task to somehow "run" the report and send the report via a workflow or 2) run the script (recurring task) to populate the temp tables and then use Sage Workflow and Alerts to create the report that is pointed at the temp tables.

The script/report has many parameters to consider and some are date dynamic (but can easily be written; date$+10).

The goal is for all of this to run automatically at night and delivered via email in pdf format.