Exporting Scheduled Reports

A User wants to run a few reports on Sunday 1AM in the morning for fiscal month end reasons. They want the report to be an excel output, so they can use the data on Monday morning.

The reports are:
Material Mgmt/Inventory Mgmt/ Reports/Stock Status
Production Mgmt/Job Mgmt/Reports/Work in Process
Financial Mgmt/Accounts Payable/Reports/Received Not Invoiced

We (IT) don’t want to use the emailing functionality, because we don’t want the attachments adding to
email archiving memory, not to mention the precedence it could set and more people asking for the same thing. We would also prefer not to create custom BAQ’s and then run a BAQ Export…it is more to maintain and people can question the accuracy of the BAQ data, whereas the direct canned reports they can’t (mostly).

We decided to schedule the report with a 1 week archive, so the User could get the data on Monday. The issue now is that we would prefer to control the scheduling, but if we schedule it then the User can’t see the archived document. We do not give the general user community the “Display All Tasks” privilege. Any other ‘Standard’ scheduling options I am missing?

You mean that you don’t want other users using the “1 AM First of the Month” schedule?

How about a uBAQ, that would let you change SysAgentTask.SubmitUser after you’ve scheduled it?

Edit

Looks like the SyAgentTask table is completely Read Only. The SubmitUser can’t be updated via uBAQ.

Maybe a Pre-Proc BPM to alter the SubmitUser field?

The submit user acts as a filter. As far as I can tell it does not link to anything else. I had a routine in 500 where I was able to change reports to different users via a bpm. For some reason I never moved that from DEV into Production, so I’ve lost it.

Not just the 1AM, but any schedules. As a general rule we don’t want users scheduling reports because of the load it could put on the system, if it got out of control. I am not techy enough to know if your suggestion would work. Again, we are hoping to avoid customizations…just standard functionality. Thanks.

So you have no schedules defined at all? And users only option when submitting a report is “Now” ??