Consolidation & Financial Planning

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.

For more information, see Searching in Ledgers and Schedules.

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.

For more information, see Assigning Data.

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.

For more information, see Creating and Configuring Views.

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.

For more information, see Creating and Configuring Views.

As of this release, a change log is available in Lucanet Consolidation & Financial Planning. It shows what changed, when, and whether a user or the system did it — covering new entries, edits, deletions, and moves.

You can open the change log from each workspace. It lists the element, its unique identifier, its parent when relevant, the action performed on the element, and, depending on the workspace, additional columns. In the Journals workspace, for example, change log entries for manual and Excel Add-In postings additionally offer a Predecessor link in the Version column that opens the previous version in a new window, so you can compare what changed without leaving your audit trail.

You can sort, filter, and page through the change entries of the log:

You can now open the original source document for a posting stored in your Document Management System (DMS) via the Show postings dialog.

To enable this function, a DMS script for opening scanned documents must be configured in the data source used for the import.

A new Executed on field in the data source lets you choose whether the script runs on the server or a Script Execution Application (SEA).

This new feature is supported for cloud- and web-based document management systems, including SharePoint.

Consolidation 1 now also supports wizard-assisted Inventory consolidation, as an elimination type for intercompany profit or loss contained in stock.

In the Consolidation areas workspace, you can configure default values per consolidation area, including the balance sheet items that contain the profit or loss, the contained profit or loss portion, and optional deferred tax and reclassifications within the P&L and/or the balance sheet. Deviating values can be defined per pair combination.

In the Journals workspace, the Inventory consolidation wizard applies these settings per intercompany relationship and lets you refresh and override the percentages before saving.

As of now, additional keyboard shortcuts are available for tables and the detail view, allowing you to work faster without a mouse.

All shortcuts are also accessible with ALT key combinations to ensure compatibility across different browsers.

For more information on keyboard shortcuts, see Using Keyboard Shortcuts.

The app for Equity Elimination now handles negative equity carrying amounts as part of the subsequent measurement of associated companies under the equity method. The app automatically determines the applicable workflow based on the carrying amounts of the current and previous periods and creates the required consolidation postings to offset a negative carrying amount where applicable.