This release includes an important enhancement to our result export feature, cash enhancement and many more:
- Export results data in how you see it
- Report duplicate and filtered items separately
- Cash - download Statement Data to Excel
- Support for multiple MT535 and MT536 messages in the same files
- UI upgrade for Audit log
- Additional information for users in Data Platform
- Other enhancements
- New features available in Data Prep module
- Bug fixes
Updated 8-Oct-2020:
- Added new session about Data Prep module
- Added Data Platform enhancement
- UI upgrade for Submission log will now be available in next release
Export results data in how you see it
During exception investigation, internal or external communications, you often want to export a subset of the result data to Excel in a particular format. You can now do that directly from the result screen.
By using the new option to download “Current view as Excel”, Duco will generate an Excel file that contains only the data according to your filters (including their roll-up constituents, where applicable), and using the current column ordering and hiding settings.
You can do this also via a new REST API Post endpoint, by passing the filtering criteria and column settings in json. Refer to our API documentation for details.
Note that with this change, the button to download Process configuration in PDF has been repositioned to under the Download menu.
Report duplicate and filtered items separately
In generic reconciliation processes, you can choose what data you want to report through result control. Data that are deemed as duplicates (rows of data that have the same values for all record tracking keys) often require investigation and manual actions, whereas data meeting your filter rules criteria can simply be ignored. You can now choose to report them separately, giving you the flexibility to minimise noise in the result data and help focusing investigation efforts.
Related Data Platform change
As a result of this enhancement, there is also corresponding change to Data Platform schema. Please refer to the Data Dictionary from the Duco app for more information.
Cash - Download Statement Data to Excel
You can already download to Excel the Cash Account Summary information and Transactions in order to support downstream reporting and processing. These are now supplemented with the ability to download the information in the Statements screen to Excel using a new API call; supporting clients to demonstrate that controls are in place, work is being completed and produce balance level reporting.
See the API documentation for more information.
Support for multiple MT535 and MT536 messages in the same files
As SWIFT messages are either routed from the SWIFT network or used as a standardised output format from internal system, they are often grouped by message types and combined into a single file. As well as supporting zipped files of multiple individual messages, we can now process single files with either multiple MT535 or MT536 messages separated by either a carriage return or empty line.
UI upgrade for Audit log
In this release, the Audit log screen in the Administration module have been upgraded to the new UI framework with usability enhancements. You can now find the log entry you are interested in by using the column filters.
Additional information for users in Data Platform
4 columns have been added to the users and users_time_series views in Data Platform, giving you additional information about user status and activities.
Note that these information will not be back filled with historical data, meaning that new information will only be available after the release when there are user activities (e.g. login, suspension).
See the Data platform documentation through the Help menu in the app for more information.
Other enhancements
Notification setting going through change management
Notification settings within a process are now included in the change management process. This means you can toggle these settings in a staging copy, when raising a change request and it gets approved by your colleague, those new settings will be applied to your production process.
Similarly, if you use Development environments, you can now promote these setting changes between sandbox, testing and production environments.
Note that even though you can change the Notification settings in staging copies, no actual notifications will be sent from them.
Submission window through change management in Development environments
Similar to notification settings, Submission window settings are now included in the change management process, through development environments.
New features available in Data Prep module
The new Duco Data Prep module has been launched for early adopters to try out the new way of transforming and normalising data from multiple sources and pass through for reconciliation.
In this release, we have enabled the following features in the module so that you can:
- Feed transactions to a cash reconciliation
- Trigger snapshots automatically
Feed transactions to a cash reconciliation
You can now create a new cash reconciliation process with one or both inputs coming from a data prep process. In this release, you can transform and normalise cash transaction data from statements in different formats (e.g. MT940, MT950, CSVs) and combine as one input for your cash reconciliation.
Feeding balance data in statements will come soon.
Trigger snapshots automatically
To manage all the files coming in from multiple sources, we are providing you more flexibility around when you want a snapshot to be created by Duco automatically. In this release, you can add triggers to your Data prep process, either:
- Completion - when a file from all sources have been received;
- Submission - when a file from any of the sources has been received.
Bug fixes
|
Issue addressed |
Description |
|
Workflow rules use deleted labels |
In some cases the workflow rules are taking into consideration the labels that were already removed from the records. |
|
Removing a record from a roll-up in a cash process breaks Audit log export |
Removing a constituent from the rolled-up record in a cash process affects the ability to download the environment Audit log. |
|
Error message is not shown promptly when a Data input is created for only one side of the process. |
An error message should pop up informing about the need to create the second Data input to complete the setup of an automatic file submission for a process. However, this message is not displayed on time. |
|
Cash submission can fail when the balance extraction is enabled but regex is blank |
In some cases submission of a file to a cash process can fail if the balance extraction regex is blank and the balance extraction box is checked. |
|
Issue with reading the first row of data in some reference data tables |
When a delimited file contains headers, the starting row is misinterpreted and causing problem processing the first row of data. |
|
Switching on/off several times the Change control in a staging copy blocks the process |
Switching on/off the Change control in a staging copy several times makes the process stuck and shows the configuration as blocked while it is not. |
|
Inserting row into reference data table inserts it at the bottom of the current page |
While adding a new row to the reference data table manually, the row gets added at the end of the page rather than on the top. |
|
UI issue when clicking 'Re-use previous data' for a single-sided process |
In a single-sided process a user can notice 'Null' for the right hand side file when clicking on run the process and on 'Re-use previous data'. |
|
Improve usability in Process setup wizard |
Enhance field navigation using tab and default to use Generic files as input. |
|
Account overview not showing full process names |
When cash process names are too long, user cannot see the full name in the process filter option and in the main table. |