This month’s release introduces a significant increase of performance of our Data Platform as well as functional and governance enhancements in the Data Prep module.
Data Prep
Use information in submitted file name in rules
Often there is useful information embedded in the file name submitted to Duco that you may want to use in Data Prep processing. For example, part of the file name may be the trade date that applies to the transactions in that file.
Now you can use the submitted file name as part of your Map & Transform rules or Filter rules in Data Prep, so that you can utilise the powerful Duco Natural Rule Language (NRL) to extract and use the information inside the file name for your business logic.
Enforcing configuration changes to go through 4-eye approval
Duco brings high agility to you and your team because of its no-code, self-service nature. At the same time we also provide strong governance and change management features to make sure no one can abuse the flexibilities.
Similar to our reconciliation processes, once your Data Prep process goes into production, you can now lock down the configurations so that any changes will need to go through a staging copy and subsequently a 4-eye approval process.
Data Platform
Improved version of Cash Data Platform
We have been working extensively on a new schema for the Cash Data Platform that will allow our users to create various MIS reports. This change allows for a more comprehensive list of views and columns within the the cash module but also delivers a more stable environment when querying results.
If you are interested in trying it out, please contact your CSM!
Improvement to syncing times
We have worked on multiple upgrades with the objective to improve the overall syncing times The main benefits within this release are on the Cash Data Platform so with this release you should be seeing further improvements on this matter.
Updated documentation
We are constantly aiming to improve the performance of cash_results view, so we decided to split this into two views. One will have non-variable columns and the other one will show variable columns. We have updated documentation in your instance to reflect this new schema.
Fixed bugs
|
Issue Addressed |
Description |
| Account label filter ignored for Excel export in cash processes | When a filter is applied to multiple transactions with the same account, labels and exported to Excel the expectation is that only transactions matching that filter should be exported however this was not the case. |
| Balances errors occurred after manually adding cash transactions | If a statement had a transactions balance error, adding a transaction to it manually will not make that error go away despite the balance being in order again. |
| Ungrouped transactions count was not updating correctly in cash processes | When there were ungrouped transactions, if the accounts they belong to were grouped via uploading an account import file, triggering matching will not cause recalculation of records in buckets, causing incorrect count in the UI. |
| Improved performance for exporting workflow buckets in two-sided processes | When exporting an Excel file from any of the workflow buckets the system was including all auto-matched records and was filtering them afterwards, slowing down the process. With this fix the performance will be considerably improved as the filtering happens in earlier stages. |
| Processes unable to be promoted when an NRL rule is disabled or incomplete | When a user is trying to promote a process to the different environment with a rule that is disabled or incomplete the promotion would fail. Now users can create and disable or push through incomplete rules and the process promotion will be successful. |
| Excel export of current view fails when two-sided reconciliation uses a data prep file | When a 2-sided process had an input from data prep, the Excel export of current view failed to generate and to open. |
| Email notification settings are not promoted from the Staging copies to the Parent process settings | In rare cases after certain steps, the email notification settings in the Staging copy were crashing which caused issues during promotion and these settings were not visible in the Parent process. |
| Incorrect error message shown in UI | Correction of error messages in the UI screen to allow users to triage the issues properly. |
| Not possible to delete pending submissions in Data Prep | In some cases the users were not able to delete pending submissions and were getting the 'Unexpected token' error in Data Prep processes. |
| The process configuration PDF file is not available for downloading | In some cases when a process was run during the background maintenance, the PDF file was blocked and not available for download. |
| The system duplicates the files submitted to processes via API | In some scenarios files submitted to Duco via API were appearing in the submissions page twice for a single API call. |