Help & Support ↗ Lucanet Learning Space ↗
Getting Started
Global Functions
Administration
Extended Planning & Analysis (xP&A)
Consolidation & Financial Planning
User Interface of Lucanet Consolidation & Financial Planning
General Functions
Basic Configuration
Dashboards
Reporting & Analyzing
Import and Journals
Journals
Importing Data into Reporting Entities
All Steps at a Glance
Defining a Data Source
Creating Assignment Tables
Creating and Executing the Data Import
Assigning Data
Finalizing Data Import
Updating Data Imports
Importing data into Lucanet.Financial Warehouse
Creating and Executing Scripts
Configuring Period Locks
Planning
Consolidation
Dimensions
Excel-Integration
Workspace Configuration
ESG Reporting
Disclosure Management
XBRL Tagger
Lease Accounting
Banking & Cash Management
Data Collection
Tax Compliance & Reporting
Glossary

Assigning Data

Overview

If, during a data import, new elements have been read in for the first time from the dimensions Accounts, Reporting entities, Cost centers, Partners, Transaction currencies, Data levels, Adjustment levels, or Transaction types, these must be assigned (only once).

Missing Assignments

The data cannot be imported until all missing assignments have been rectified. If there are any assignment errors, these assignment errors will be displayed in the detail view of a data import, for example as follows:

Detail view of a data import. The missing assignments are displayed.
Display of missing assignments in a data import

Assigning Data

To edit missing assignments:

1

Click 2. Assign in the detail view of the import.

The assignments are displayed, for example as follows:

Assignment table with missing assignments
2

A summary of the missing assignments of the import process is displayed in the Missing assignments area. In each case, the system displays the number and dimension (of the assignment area) of the elements from the data source that could not be assigned to any element in the Lucanet database.

Missing assignments must be edited on the tabs with the name displayed in red.

3

Click Edit.

4

If necessary, activate the check box Apply descriptions from the data source during assignment if the descriptions are to be copied from the data source during assignment. By default, the description of the element is used in the Lucanet database.

5

If necessary, in the Target area, click to show further ledgers. All subledgers and all statistical ledgers released as a target for data imports can be selected.

6

Assign all elements of the data source to elements of the Lucanet database. The assignment is made using the same principle. The following options are available:

7

Click Save to save the assignments. The assignments are performed automatically when the data import is updated.

Assigning Elements Automatically

To assign elements automatically:

1

Click Assign automatically.

Excerpt from the assignment table. The tooltip for the 'Assign automatically' button is displayed.
Assigning elements automatically
2

The Assign automatically dialog is displayed:

'Maintain assignment table' dialog
'Assign automatically' dialog
3

Choose one of the following assignment options:

Assignment Options

The following assigment options are available:

Assignment dependent on homonymous names

For this assignment type, the system searches the Lucanet database for elements with the same name. Leading spaces and zeroes are removed during the search. When elements with the same name are found, a corresponding dialog is opened.

Click Assign to copy the proposed assignments.

  • If several matches are found, then the object cannot be assigned automatically from the data source.
  • If no match is found, the comparison is repeated without differentiation between upper and lower case. If the system still cannot find a match, a search is then performed without special characters. If this comparison still provides no result, then the element cannot be assigned automatically.

Assignment dependent on identical account numbers

For this assignment type, the system searches the Lucanet database for elements with the same account numbers. Only the part of a name up to the first blank is checked. All characters other than figures are deleted from this part. Leading zeros are then removed. These extracted numbers are compared directly.

If matching numbers are found, a dialog will be displayed, in which you can specify the suggestions you want to accept.

If several matches are found (e.g. identical account numbers for the representation of cost centers and cost carriers), the element cannot be assigned automatically from the data source.

Assignment according to chart of accounts

With this assigment type, the assignment is made using a chart of accounts.

If you choose this option, select the applicable chart of accounts from the Chart of accounts drop-down list.

During assignment, the following dialog is displayed:

Assigning Elements Manually

To assign elements manually:

1

In the Data source area, click the desired element(s).

2

Do one of the following:

  • If a new element is to be created for the element in the Lucanet database, in the Target area, select the item or the folder under which the element is to be created and click Assign and create ().
  • To assign the element to an element in the Lucanet database, select the desired element in the Target area and click Assign(
    ) .
Assign elements
3

Repeat steps one and two for each element or the elements to be assigned together.

Additional Icons and Functions in Assignment Tables

The following additional icons and functions are available in assignment tables:

Switch between the display of unassigned elements and all elements.

Displays the Partner column in the data source area. An existing partner can then be chosen from a drop-down list in the column.

The partner column can be displayed only on the Accounts tab.

Indicates that the name of the elements are not identical, i. e. the element in the Lucanet database has a different name than in the source system.

The element has not been assigned.

Excerpt from an assignment table. The 'Show target' context menu command is displayed on an account. The context menu command is outlined in red.
'Show target' in the 'Data source' area of an assignment table

The following commands are available in the context menu of an element:

Show target: shows the element assigned to an element from the data source in the Lucanet database in the Target area.

Remove assignment: revokes an existing assignment.

Delete current row: deletes the current row from the assignment table. The deleted element will not be imported.

'Uses' Tab

By which elements the assignment table is used is displayed on the Uses tab.

You can open the respective element by clicking the link in the Name column.

Last updated on Aug 16, 2023

Table of Contents
Assigning DataOverviewMissing AssignmentsAssigning DataAssigning Elements AutomaticallyAssignment OptionsAssigning Elements ManuallyAdditional Icons and Functions in Assignment Tables'Uses' Tab
Related Articles

Company

Legal Notice

© Copyright 2026 - Lucanet AG