Importing Postings into Consolidation & Financial Planning

Getting Started

Global Functions

Lucanet Lume

Data Hub

Administration

Extended Planning & Analysis (xP&A)

Consolidation & Financial Planning

ESG Reporting

Disclosure Management

XBRL Tagger

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

Creating Postings

Reversing Postings

Exporting Reports and Postings

Importing Postings into Consolidation & Financial Planning

Banking & Cash Management

Data Collection

Tax Compliance & Reporting

Glossary

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

Before you can import the postings 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:

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:

The dialog for creating a script is displayed. — 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:

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:

The dialog for creating a data source is displayed. — 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 script you created in the previous step.

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:

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: