With the new Balance clearance wizard, you can clear the balances of all general ledger accounts in one step instead of entering every account manually, for example for a deconsolidation. The wizard replaces the Deconsolidation wizard function of Lucanet.Financial Client.
When you create a manual posting, click Balance clearance wizard in the toolbar of the Values tab, select the Month of clearance and the Adjustment level (basis) whose balances are to be cleared, and click Apply.
In the posting table, the wizard then creates one row for each general ledger account that has a non-zero balance, and enters the value that clears this balance. The wizard splits balances by partner where needed and assigns each row the transaction type for disposals from the consolidation group defined in the account's transaction type category. When you save the posting, the account balances are zero at the end of the selected month.
'Balance Clearance Wizard' dialog
The wizard is available in the Journals workspace, in ledgers and schedules, and in the Show postings dialog, for users with read permission for the general ledger account hierarchy and data access write permission for the general ledger.
The app for equity elimination in Lucanet Consolidation & Financial Planning now automatically consolidates IC transfers for fully consolidated investments when the effective group share changes without loss of control.
In the Master Data Administration of Lucanet Consolidation & Financial Planning, you can now sort table entries and filter them by column values or periods.
Sorting and filtering in master data administration
In Lucanet Consolidation & Financial Planning, the Accounts tab of assignment tables now provides a context menu in the Target area.
You can create and rename accounts and items, move elements, change their order, and delete elements while assigning imported data.
Assign account maps a source account to an existing target account; Create and assign creates the target account under an item and assigns it in one step.
Context menu in the 'Target' area
The available commands in the context menu depend on which element is selected.
The following dialogs for importing data into reporting entities can now be opened in full size, so that you can see more data at once without scrolling:
The dialog for configuring and starting an import. This is especially helpful for script-based imports with many settings.
The dialogs that show the proposed assignments when you assign elements automatically using the option Assignment dependent on homonymous names, Assignment dependent on identical account numbers, or Assignment according to chart of accounts
To enlarge one of these dialogs, click Open full size in the dialog header. To return to the regular size, click Exit full size.
'Assign automatically' dialog with the 'Open full size' button
In addition, the assignment table that opens during an import now always uses the full width and height of the screen.
The Analyze database function in Consolidation & Financial Planning now displays the tables of a connected database, so that you can find and inspect a table without knowing its name beforehand. With Load table information, the tables are displayed as a tree of catalogs, schemas, and tables. When you select a table, its column structure and the number of records are displayed. With Show query results, you open a query window that immediately displays the data of the selected table.
Table tree and table details in the 'Analyze database' dialog
In addition, the following functions are available:
Connection information: Displays the JDBC driver and the database system of the connection, each with its version.
Query history: Lists the statements that you have run in a query window, so that you can reuse them without typing them again.
When you test a database connection in Consolidation & Financial Planning, you now select in the Test connection dialog whether the test is executed on the server or on a Lucanet.Script Execution Application (SEA). This lets you also test connections to databases in your local network. The Test connection button is now also available in view mode.
The Show values in expanded format setting in Lucanet Consolidation & Financial Planning determines whether an item row displays values while its subordinate elements are expanded. If you deactivate the setting, the expanded item row is displayed without values.
The setting is available when creating or editing items in ledgers and schedules and in the target tree of assignment tables. For new items, the setting is activated by default. Item references inherit the setting from their referenced item.
The Give feedback option in Lucanet Consolidation & Financial Planning provides a way to share your feedback about the solution. You can find the option at the bottom of the solution's side menu, below Workspace configuration.
You can now open the detailed log of an execution directly from the change log. For Apps, Scripts, Data Imports, and Execution settings, the change log window now includes an Execution log tab that lists every run of the element, including date/time, user, status, and a link to its detailed process log.
Execution log
The process log shows the individual steps of the execution in an expandable tree, including their timing, duration, and progress. You can activate Show debug messages for additional technical details.
Process logs can be downloaded as a text file (.txt) or an Excel file (.xlsx).
Note: Execution and process log data is kept for a rolling retention period of 30 days. Executions older than that no longer appear in the execution log, but remain visible as an Executed entry on the Change log tab.
The app Copy postings into other consolidation areas now also copies the Cancel posting setting (Cumulative after the last month or After every month) of a base posting to the corresponding target posting. Previously, this setting had to be activated manually on the target posting after the copy.
Lucanet.Script Execution Application (SEA) is now updated automatically. Once a day, from 06:00 local time, SEA checks for a newer version and installs the new version. For SEA installations, the automatic updates mean the following:
Security fixes, bug fixes, and new SEA capabilities reach every installation as soon as they are released.
You no longer need to check each SEA installation individually for updates in Lucanet.Software Manager.
If the computer running SEA was switched off or asleep at 06:00, SEA checks for updates about 5 to 15 minutes after the computer starts or wakes up.
With the new Analyze database function, you can run read-only SQL queries against a connected database directly in Consolidation & Financial Planning, without using a separate database tool. Typical use cases are verifying that data was imported correctly and analyzing the database of a source system. You can open multiple query windows at the same time and compare the data of related tables side by side.
The Analyze database function is available in the detail view of the following elements: elements of type Connection, data sources for importing data into Lucanet.Financial Warehouse, and data sources of type Lucanet.Financial Warehouse (#2068) for importing data into reporting entities.
The new app Copy postings into other consolidation areas lets you copy manual postings and translations with historical exchange rates from one consolidation area to another with a single execution, replacing the manual reconciliation and copy-pasting previously required.
Configure a base and target consolidation area, the consolidation unit assignment between them, and the posting types and folders to include. Each execution replaces the postings created during the previous run, so the app can be re-executed safely at any time.
Note: With the current release, the Cancel posting setting of a posting (Cumulative after the last month or After every month) is not copied to the target posting. This feature will be provided with an upcoming release. If needed, activate the setting manually on the target posting after the copy.
You can now search for elements — such as items, accounts, formulas, folders, references, and total lines — directly in ledgers and schedules using the new Search field in the dimension bar. This is especially useful in large or deeply nested hierarchies, where the element you are looking for can be several levels deep, or hidden behind a collapsed node.
Matching elements are highlighted and you can use the navigation arrows to move between matches.
Search field in the dimension bar with highlighted matches
Also in assignment tables when importing data into reporting entities, you can now search for elements directly in the Data source and Target areas. Enter a search term and press Enter to run the search; matching elements are highlighted, and you can navigate between results using the arrow keys.
Search fields in the 'Data source' and 'Target' areas
Two new column types are now available when configuring views for ledgers and schedules: Value in % displays the value of a column as a percentage of a reference column, and Exchange rate displays the exchange rate between the display currencies of two columns.
Views can now be configured to hide the drop-down lists for dimensions that are fixed to a single element or not used in the dimension bar. Activate Hide fixed or unused dimensions when creating or editing a view to simplify the dimension bar for its users.
'Hide fixed or unused dimensions' option when configuring a view
