Bureau Reports
Purpose
Automates the downloading of BACS Bureau reports.
You can use the Bureau Report Download node to create a workflow that automatically connects to the BACS report service and downloads new bureau reports in various different formats. Workflows can be built that email downloaded reports to you or securely download them to your own environment using the Paygate Agent.
In the following simple example a trigger is created to automatically run the workflow twice a day. When the workflow is run it connects to BACS and downloads all newly created bureau reports across all SUNs. The reports are then added to a zip file and moved to a new folder. Finally an email is sent to staff informing them that reports are available.
Workflow Configuration
Report Type
Select the reports that you wish to download by ticking the boxes next to the report name.
Report Format
Determines the format of the downloaded report. Not all reports are available in all formats. The table below show which reports are available in the different format.
| BACS Report | XML | HTML | CSV | |
|---|---|---|---|---|
| Advice of Unpaid Direct Debits (ARUDD) |  |
|
|
 |
| Unapplied Automated Credits User Copy (ARUCS) | |
|
|
|
| Arrival | |
|
|
|
| Input | |
|
|
|
| Withdrawal | |
|
|
|
| AUDDIS File Acceptance | |
|
|
|
| AUDDIS File Rejection | |
|
|
|
| Submission Component History | |
|
|
|
| Direct Debit Indemnity Claim Ad hoc challenge and response audit trail report | |
|
|
|
| Direct Debit Indemnity Claim Service User In Progress Challenge and Response Report | |
|
|
|
| Direct Debit Indemnity Claim In Progress Service user reason code 7 requests report | |
|
|
|
| ADDACS | |
|
|
|
| Advice of Bank Returned Direct Debit Instructions (AUDDIS) | |
|
|
|
| AWACS | |
|
|
|
| DDIC Advice | |
|
|
|
Save Path
This is the path that the report files will be automatically downloaded to when the workflow runs. The path is in your customer secure file area. Use the folder browser button to navigate to the desired folder. If required you can use the Agent to automatically retrieve the downloaded reports and store them within your organisation.
Note You cannot use tokens such as {dd}, {yyyy} etc for the report download path - the path must be fixed, for example \bacs\reports. To use token based, dynamic folders with downloaded reports, use a combination of ‘Create Folder’ nodes and ‘Move File’ nodes and use tokens in the folder/file node paths.
Report Age
Determines the maximum age of reports that are eligible to be downloaded. For example, selecting ‘Current Day’ will mean that only reports that have been generated today will be eligible to be downloaded. The dates used refer to the date the report was generated by BACS and not the processing date.
Download previously accessed reports
The reports service keeps track of whether a specific report has already been downloaded. You can ignore reports that have already been downloaded (and perhaps minimise duplicate reports) by unselecting this option.
Download each SUN’s reports into a separate folder
Selecting this option will cause the workflow to gather reports for each SUN in their own sub folder.
For example, if your save path is ‘\reports’ and you download reports in xml format for two SUNs: 1111111 and 222222; the report will be stored as follows:
\reports\111111\report1.xml
\reports\111111\report2.xml
\reports\222222\report1.xml
\reports\222222\report2.xml
\reports\222222\report3.xml
Prefix downloaded report filenames with the associated SUN
Selecting this option will modify the filename of each downloaded report by appending the sun following by a hyphen, followed by the original report filename.
Using SUN ‘111111’, If the original filename is report1.xml then the resulting filename will be ‘111111-report1.xml’.
Service User Numbers
This is a list of BACS Service User Numbers (SUNs) that are linked to your Bureau User Number (BUN). When the workflow is run, reports will be downloaded for each of the SUNS in the list.
You have two choices for the formatting of the SUNs:
- Comma Delimited (Also know as Comma separated or CSV)
- Newline Delimited
Comma Delimited
Enter the SUN’s separating each one with a comma:
111111,222222,333333,444444,555555
Newline Delimited
Enter the SUN’s with a newline between each sun
111111
222222
333333
444444
555555
Use SUNs from Bureau Customers
Clicking this button will gather all SUNs used across all of your Bureau customers and added them to the SUN text area. This can use useful to quickly add SUN that Paygate already knows about.
Note - Clicking this button will replace any SUN’s already in the SUN text area.
Sort
Will attempt to sort the list of SUNs in alpha-numeric order.