Position Mapping | Lucanet Knowledge Base

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

Banking & Cash Management

Data Collection

Tax Compliance & Reporting

Tax Administration

Income Taxes

User Interface of Income Taxes

Modules and Additional Functions in Income Taxes

Income Tax Forms

Master Data

Periods

Countries

Reporting Dimensions

Companies

Foreign Branches / Fonds

CoA Group

CoA Company

Toolbox

Interfaces

Configuration

Structure

Position Mapping

Import Mapping

Administration

Company

(Sub-) Group

Reporting

Pillar 2

Country-by-Country Reporting

First Steps in Pillar 2 and CbCR

Tax Balance

Tax Services

Glossary

Item (or account) IDs often vary between different IT systems. It is therefore necessary to create an assignment for these item IDs (mapping) before the import process.

In the Position Mapping workspace, you can define how source items you import from a source system are to be mapped to the target fields when using an interface structure of type Import. Multiple mapping files can be created for each interface and period here.

This article describes how to create and configure item mappings. First, a mapping is created and an editable Excel file is stored for the mapping. This Excel file is then downloaded, the item assignment made in the Excel file, and the Excel file uploaded again.

The Position Mapping workspace is displayed, for example, as follows:

To create a new mapping:

Choose the period for which you want to create the mapping.

Choose the balance type for which you want to create the mapping.

Choose the desired mapping type.

The mapping type defines from which target and into which source data are to be transferred and assigned by means of the mapping.

Enter the name for the mapping under Name of template.

You can optionally enter a description for the mapping.

Specify what type of mapping this is. Choose one of the following options:

Default mapping

: The mapping is defined as group-wide mapping.

Ergänzung zum Standard-Mapping (Supplement to default mapping)

: The mapping supplements the group-wide mapping. Items from the default mapping can also be overwritten with this mapping. For this mapping to be used additionally (= as a supplement) to the default mapping for the import process, it must be explicitly assigned to the company in the company master data.

Alternatives Mapping (Alternative mapping)

: Activate neither of the two options if the mapping is to be defined as an alternative mapping. An alternative mapping is used whenever a company should not use the group-wide mapping, for example because it is supplied from a different source system with a different chart of items. If this alternative mapping is assigned to a company, this company will use only this alternative mapping for the import process.

Click the + icon to the left of the mapping name to create the mapping and generate a mapping file in the form of an Excel file.

After you have created the mapping and the mapping file has been generated in Excel format, you can configure the item assignment in the Excel file. Proceed as follows: