This page archives the release notes for older versions of Lucanet Data Collection.
The versions of all solutions that you are currently using and those of the CFO Solution Platform are displayed when you select About Lucanet from the Help section in the CFO Solution Platform.
In the intercompany validation results, you can now display the contact information of a counterparty's collectors. Click the phone book icon next to the counterparty name in the section header to open a dialog that lists each collector assigned to the counterparty in the reporting package, with their name and e-mail address. This way, you can follow up on an intercompany difference or missing data without leaving the application.
Contact information of a counterparty's collectors
The results detail table now displays local accounts as expandable sub-rows. Where an item or account has a local account drill down, its local account sub-rows are displayed directly beneath the row, so you can see which local account causes an intercompany difference without returning to the form. Each sub-row displays the local account name and, depending on the configuration, the values in transaction currency, in reporting currency, or in both.
The intercompany validation results now identify counterparties that have not entered any data for a validation rule. The counterparty section header displays No data where the calculated difference normally appears, and the counterparty's rows are displayed with empty value columns. Your own values are displayed unchanged.
A counterparty is treated as having no data when it has not entered a value on any of the items or accounts in the validation rule definition. A validation rule only receives the status Passed when every counterparty has entered data on these items and accounts and the validation rule condition is met.
Counterparty without data in the intercompany validation results
For intercompany validation rules that reconcile aggregated values in group currency, the results detail table now includes an Exchange rate column. Each row displays the numeric rate applied to convert the reporting entity's values to group currency. When the counterparties have different local currencies, each reporting entity's rows display the applicable rate. If a reporting entity's local currency is the same as the group currency, the column displays a rate of 1. For validation rules that reconcile aggregated values in transaction currency, the column is not displayed.
Administrators can now add formula columns and formula rows to pivot tables and CFP pivot tables.
A formula column calculates its values automatically from an arithmetic expression that references other columns in the same or a different table, or numeric constants. Formula columns display the ∫ icon in the column header and are read-only for collectors.
A formula row calculates its values automatically from other rows in the same or a different table. Formula rows display the ∫ icon next to the row name, are excluded from the total row sum to prevent double-counting, and are read-only for collectors.
When a table contains both formula rows and formula columns, you can set a Formula precedence on the element to control which result is displayed in cells at their intersection.
CFP Pivot tables based on Schedule workspaces now automatically include Value query columns. Value query is a transaction type specific to a Schedule in CFP. These columns are read-only for collectors, can be used as operands in total and formula columns, and are included in CFP imports. They are excluded from Excel and Lucanet.Financial Warehouse imports.
Transaction type and adjustment level are now available as drill down dimensions for both rows and columns in pivot table and CFP pivot table elements. Together with local account, cost center, and partner, all five CFP dimensions can now be configured as drill down dimensions.
Published form templates can now be edited at any time — publishing no longer locks a form template. When you edit a published template that is linked to one or more reporting packages, a confirmation dialog lists all affected packages and you can move the template back to Draft state. The linked reporting packages move to Invalid status and cannot be used to start new data collection processes until the template is republished.
If you delete a row, column, or section element that is referenced by a validation rule formula, a warning dialog lists the affected rules before the change is saved. The affected rules are paused automatically and do not execute until they are republished.
Active and completed data collection processes are not affected by template edits.
Administrators can now add optional instructions to a form template using a rich text editor in the detail view of a form template. The instructions are copied to each form when a data collection process starts. Collectors access the instructions via the Show instructions button in the form header, which opens a dialog displaying the instruction text.
'Instructions' field in the form template designer
Intercompany validation rules now support optional tolerance thresholds per currency. You can configure an Absolute threshold, a Percentage threshold, or both. When both are set, the rule passes if the difference falls within either threshold.
The intercompany validation results now distinguish four statuses:
Passed — values match exactly, or the difference falls within the configured thresholds
Warning — a difference was found and no thresholds are configured
Failed — the difference exceeds the configured thresholds
Not evaluated — the rule could not be evaluated, for example because no transaction currency values were entered or none of the currencies match a configured threshold entry
The calculated difference is always shown in the results, even when the result is Passed.
Threshold configuration in an intercompany validation rule
Regular validation rules that reference more than one form template are now only executed if all referenced form templates are included in the reporting package. Rules that reference one or more templates that are not in the reporting package are skipped and do not appear in the validation results. No administrator configuration is required.
When a form is open, you can now navigate directly to another form for the same reporting entity without returning to the data collection list. Click the form template name in the navigation path at the top of the screen to open a drop-down menu listing all form templates you are authorized to access for the current entity within the current process. The drop-down menu displays each form's name and current status.
Data collection administrators can now reopen a form that has been approved. Reopening transitions the form back to In Progress, notifies the collector, and allows corrections to be made through the normal editing and approval process. Other forms in the same reporting package are not affected.
Reopening a form and changing its data does not automatically update any posting already imported into Consolidation & Financial Planning. A data collection administrator must re-execute the Import from DC data import in Consolidation & Financial Planning after the form is reapproved.
Data Collection now supports exporting postings directly to Consolidation & Financial Planning. Administrators mark one or more currency columns per CFP Pivot table as Used for postings in the form template. CFP then retrieves and imports the postings via the existing workflow for a data source of type Provision via script using the dedicated Import from DC script.
A new element type, Dynamic table, lets data collectors add, duplicate, and remove rows themselves during data collection, up to a maximum that Data Collection administrators configure. This is useful for variable-length data — for example, fixed asset lists, intercompany loan schedules, or provision schedules — where the number of rows differs from one reporting entity to another.
Data Collection administrators define the column structure once in the form template, and each data collector enters as many rows as they need during data collection.
You can now duplicate any element directly from the detail view of a form template. The duplicate inherits the configuration, mappings, required-field status, and all language labels of the original, so you do not have to rebuild similar elements from scratch.
Element duplication is available only while the form template is in Draft state.
You can now change the display order of rows and columns in a Pivot table or CFP Pivot table by drag-and-drop. Rows can also be moved under a different superordinate row to restructure the hierarchy. Collected data, drill down configurations, and aggregations are not affected by reordering — values stay bound to their row and column identifiers.
When you add a CFP Pivot table element, you can now choose which rows to include from the source Consolidation & Financial Planning workspace before the table is created, instead of pulling all eligible rows in automatically. Three selection modes are available — Select all, Show items only, and Custom selection — and the original hierarchy is preserved in the resulting table.
You can now group validation rules by category using free-form tags, then filter the rules list by one or more tags. Tags apply equally to Regular and Intercompany validation rules and have no effect on rule logic or execution.
Tags can be assigned to a single rule directly in the rule's configuration, or to several rules at once from the validation rules list using the new Assign tags and Remove tags bulk actions.
When configuring a Regular validation rule, you can now reference superordinate rows directly, not just the lowest-level rows. The rule uses the aggregated value of the superordinate row — the same value displayed for it in the form. This makes it easier to write rules that compare subtotals without listing each subordinate row individually.
Selecting a superordinate row in a validation rule
The Select items and/or accounts drop-down list in the Intercompany rule configuration now hides form templates and pivot tables that have no partner-related configuration, so only elements that are actually eligible for intercompany validation appear.
In the same drop-down, you can now select a superordinate row to automatically include all of its eligible subordinate rows.
The Data Collection list now shows the result of the last intercompany validation execution in a dedicated IC Validation result column, separate from the existing Validation results column. Process-level and form-level rows show the IC status; entity-level rows are empty. Point at an indicator to see the exact error and warning counts.
The new Lucanet Data Collection solution is now available on our Lucanet CFO Solution Platform!
The Data Collection solution enables you to gather, validate, and enrich financial and statistical data across all your reporting entities. With Data Collection, you can handle the entire process from distributed data entry by local finance teams to central review and approval – all in a single, web-based environment.
The cloud-based platform and seamless integration with Consolidation & Financial Planning (CFP) allow you to reuse your existing structures, dimensions, and translations directly in your data collection forms, without duplicating setup work.
Data Collection supports a decentralized collection model: local teams enter and validate their own data before submitting it for central approval. This makes the solution suitable for organizations of all sizes that want to standardize group reporting and improve data quality at the source.
Data Collection offers you:
Configurable form templates: Create flexible data collection forms from scratch or based on existing CFP structures, such as the general ledger and subledgers.
Robust validation rules: Validate data at the point of entry with customizable rules that check data quality within and across form templates, reducing errors before data reaches central finance.
Reporting packages: Bundle form templates, validation rules, and reporting entity assignments into reusable packages, and start data collection processes with just a few clicks.
Seamless CFP integration: Import reporting entities directly from CFP to keep master data consistent across solutions, with no manual reconciliation needed.
Collaborative workflow: Empower distributed teams with a clear collector-and-approver workflow that combines local ownership with central oversight.
This content was generated using AI and reviewed by Lucanet subject matter experts before publication.
