In my last 2 posts on our Ad Hoc reporting capability, I have covered most of the key features of ad hoc reporting. You can read about those here and here. Today, we will look at another key product feature. The ability to schedule reports and export data into MS Excel and PDF formats. So, the report we created earlier is listed on the Ad Hoc reporting dashboard and on clicking the schedule button, on the right bottom corner of the picture below you can schedule that report.
Any available, already created schedules for the report will be listed, there are none here yet and you can click on add to create your first schedule.
To highlight a key strength of scheduling I wii go ahead and edit one of the conditions in the report we created earlier. Instead of asking the users to input one flow code (such as say ACHD for ACH Debit), we will let users input more than one Flow Code. To do that, I will go back to the dashboard and edit the report, delete the condition that says FlowCode = ? and add a new one as shown below. I will then prompt the end user executing the report enter the conditions at runtime.
Once the changes are made, the conditions selected for the report will be as shown below.
Now we will schedule this report. Note that on clicking add,the user is prompted to enter scheduling information. End users with appropriate privileges can schedule reports to be delivered via email to inbox of selected users or even deliver it to a folder in the network. You also have the option to choose whether to create the report in MS Excel or PDF and you can also password protect it. You can also specify the scheduled time for the report to be executed. You can also choose users within the system and any external users (you can choose not to as well) to receive the reports on the schedule created.
The final, yet most interesting point is that users are also prompted to enter any runtime conditional information while creating the automated schedule as well. For instance, if your A/P organization wants to look at all outgoing payments for the day you could add a schedule (as shown below) for a daily report run at 3 PM each day that reports on ACHD and WOD, WOI - assuming you do ACH debits, and Wires out International and Domestic.
Note that you can schedule the same report as many times as you want. For example, say your receivables department wants to review the list of al Lock Box Deposits at the end of the day we can add another schedule that with FLowCode = LBDEP, as shown below and schedule it to be delivered to the receivables users.
Trust that provides a detailed review of the ad hoc reporting functionality. Note that while we originally built the ad hoc reporting module to be part of CMO, we are now making it available as part of all treasury sciences product modules. As a final note, you can export any report from the system- just execute the report and click export to excel or pdf or schedule the report to be delivered to you in the format you choose. Thank you for reading.