Importing Postings into Consolidation & Financial Planning

Documentation

Getting Started

Global Functions

Lucanet Lume

Administration

Data Hub

Consolidation & Financial Planning

Lease Accounting

General Functions in Lease Accounting

User Roles in Lease Accounting

All Steps at a Glance

Basic Configuration for Lease Accounting

Selecting a Lessee

Collecting Data

Categorizing Components

Calculating Data

Saving Postings

Reversing Postings

Exporting Reports and Postings

Importing Postings into Consolidation & Financial Planning

Extended Planning & Analysis (xP&A)

ESG Reporting

Disclosure Management

XBRL Tagger

Tax Compliance & Reporting

Banking & Cash Management

Data Collection

Glossary

Postings saved in Lucanet Lease Accounting can be imported directly into Consolidation & Financial Planning (CFP) using a script. This integration is available for users with a Consolidation & Financial Planning license.

Before you can import the postings from Lease Accounting into Consolidation & Financial Planning, you need to perform a one-time setup process, which is described in the following subsections.

To create the import script for the Lease Accounting postings:

Go to Import | Scripts.

Right-click your Lease Accounting folder (or create a new folder) and select Create | Script. The Create Script dialog is displayed as follows:

Shows the 'Create Script' dialog in Lucanet CFP with the type 'Script', the 'File' upload area with the text 'Attach file using drag and drop, or browse' and '1 file(s) max', the 'Name' field with the example value 'LeaseAccounting', and the 'Cancel' and 'Save' buttons. — Create script

In the Create Script dialog, attach the script file provided by:

Professional Services team during implementation, or

Customer Support

Click Save.

Click Edit in the top right and configure the script with the following information:

Name

: Enter a descriptive name for the script.

CFO Solution Platform URL

: Enter your platform URL.

Reporting entity

: Select the reporting entity (or entities) for which you want to import postings.

First month of fiscal year

: Enter the number of the first month (e.g., 1 for January).

Save the changes.

To create the data source for the Lease Accounting postings:

Go to Import | Importing data into reporting entities.

Right-click your Lease Accounting folder (or create a new folder) and select Create | Data source. The Create data source dialog is displayed as follows:

Shows the 'Create data source' dialog in Lucanet CFP with the type 'Data source for Lucanet.Financial OLAP Server', the 'Origin of the data' drop-down list set to 'Provision via script (#2075)', the 'Element name' field with the example value 'Lease Accounting', and the 'Cancel' and 'Save' buttons. — Create data source

Select Provision via script as the origin of the data and enter a descriptive name for the data source.

Click Save.

Click Edit in the top right and configure the data source:

Drill down to posting level

: Select the import script you created in

Creating the Import Script

Import type

: Select

Transaction figures

Data level

: Select the data level where the postings should be imported (e.g., Actual).

Adjustment level

: Select the adjustment level for the imported postings. We recommend using a separate adjustment level such as

IFRS 16

to distinguish lease accounting postings from other postings.

Dimensions

: Select all dimensions you want to include in your postings.

Cost centers

: If you are using specific cost centers in your reporting entity, enable

Use specified cost centers

Reporting entity

: Add the reporting entity for which you want to import postings.

Save the changes.

To create the assignment table for the Lease Accounting postings:

Go to Import | Importing data into reporting entities.

Right-click your Lease Accounting folder (or create a new folder) and select Create | Assignment table. The Create element dialog is displayed as follows:

Shows the 'Create element' dialog in Lucanet CFP with the type 'Assignment table', the 'Element name' field with the example value 'Lease Accounting', and the 'Cancel' and 'Save' buttons. — Create assignment table

Enter a descriptive name and click Save.

After completing the setup, we recommend that you import the Lease Accounting postings into Consolidation & Financial Planning every month in the following way: