In Lucanet Consolidation & Financial Planning, assignment tables map imported elements from the dimensions Accounts, Reporting entities, Cost centers, Partners, Transaction currencies, Data levels, Adjustment levels, and Transaction types to the corresponding elements in the Lucanet database. Define each assignment once; Consolidation & Financial Planning reuses the saved assignments for subsequent imports.

Consolidation & Financial Planning cannot import the data 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:

Shows the detail view of a data import in Lucanet Consolidation & Financial Planning. Highlighted in red is the 'Missing assignments' error.
Display of missing assignments in a data import

To edit missing assignments in Consolidation & Financial Planning:

1

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

The assignments are displayed, for example as follows:

Shows an assignment table in Lucanet Consolidation & Financial Planning with the 'Data source' and 'Target' areas. Highlighted in red are the dimension tabs and the 'Missing assignments' area.
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 Show ledgers icon 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 changes to save the assignments. The assignments are performed automatically when the data import is updated.

To assign elements automatically in Consolidation & Financial Planning:

1

Click Assign automatically.

Shows the 'Data source' and 'Target' areas of an assignment table in Lucanet Consolidation & Financial Planning. Highlighted in red is the 'Assign automatically' button with its tooltip.
Assigning elements automatically
2

The Assign automatically dialog is displayed:

Shows the 'Assign automatically' dialog in Lucanet Consolidation & Financial Planning with the options 'Assignment dependent on homonymous names', 'Assignment dependent on identical account numbers', and 'Assignment according to chart of accounts'.
'Assign automatically' dialog
3

Choose one of the following assignment options:

The following assignment options are available in Consolidation & Financial Planning:

OptionDescription
Assignment dependent on homonymous namesFor 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.

Note:
- 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 numbersFor 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.

Note: 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 accountsWith this assignment 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:

To assign elements manually in Consolidation & Financial Planning:

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 Create and assign (Create and assign icon).
  • To assign the element to an element in the Lucanet database, select the desired element in the Target area and click Assign (Assign icon).
Shows the 'Data source' and 'Target' areas of an assignment table in Lucanet Consolidation & Financial Planning. Highlighted in red is the button for creating and assigning an element.
Assign elements
3

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

On the Accounts tab of an assignment table in Consolidation & Financial Planning, you can create and maintain accounts and items directly in the Target area. You do not need to leave the assignment table to adapt the ledger structure.

To open the target context menu in Consolidation & Financial Planning:

1

Open the assignment table in the Importing data into reporting entities workspace and click Edit.

2

Select the Accounts tab.

3

Right-click an account or item in the Target area.

Shows the 'Accounts' tab of an assignment table in Lucanet Consolidation & Financial Planning with the 'Data source' and 'Target' areas and the context menu for an item in the 'profit & loss' ledger. The menu includes 'Create and assign', 'New element', 'Change order', 'Cut', 'Copy', 'Paste', 'Delete', and 'Rename'; 'Create and assign' and 'Paste' are disabled. Highlighted in red is the context menu for editing the target structure.
Context menu in the 'Target' area

The following context menu commands are available for the target structure on the Accounts tab in Consolidation & Financial Planning. Availability depends on the selected element and the permitted action:

CommandDescription
Create and assignCreates a new account under the item you right-clicked and assigns the selected source account to it. The new account takes its name from the source account. Select a source account first. This command is not available on the ledger root.
Assign accountAssigns the selected source account to the target account you right-clicked. Select a source account first.
New elementCreates an Account or Item in the target structure. Creating an account with this command does not assign a source account to it. Formula and Total line are disabled.
Change orderOpens a dialog for changing the sequence of elements at the same hierarchy level. Changing the sequence does not change existing assignments.
Cut and PasteMoves an account or item to another permitted position. Moving an item also moves its subordinate elements. Existing assignments are retained.
Copy and PasteCopies an item to another permitted position. The original assignments remain unchanged. Copying and pasting an account is not supported.
DeleteDeletes the selected account or item after confirmation. Deleting an item can also delete its subordinate elements. Source accounts assigned to deleted accounts become unassigned.
RenameChanges the name of an account or item. Existing assignments display the changed name.

Changes to the target structure in Consolidation & Financial Planning affect the underlying ledger, including its use outside the assignment table. Creating, renaming, moving, or deleting target elements takes effect immediately. Deleting an assigned target account removes its assignments; assign the affected source accounts again before importing the data.

For details on account and item configuration, see Creating and Configuring Accounts and Creating and Configuring Items.

To assign an account using the context menu in Consolidation & Financial Planning:

1

Select the account in the Data source area.

2

In the Target area, choose one of the following:

  • Right-click an existing account and choose Assign account.
  • Right-click the item under which you want to create the account and choose Create and assign.
3

Click Save changes to save the assignment table.

The following additional icons and functions are available in assignment tables in Consolidation & Financial Planning:

Icon/functionDescription
Search fieldDisplays a search field above the Data source area and the Target area. Enter a search term and press Enter to run the search for an element.
'Not assigned' and 'All' buttonsSwitches between the display of unassigned elements and all elements.
Partner iconDisplays the Partner column in the data source area. An existing partner can then be chosen from a drop-down list in the column.

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

Warning iconIndicates that the names of the elements are not identical, i. e. the element in the Lucanet database has a different name than in the source system.
Information iconThe element has not been assigned.
Shows the source context menu in an assignment table in Lucanet Consolidation & Financial Planning. Highlighted in red are the commands 'Show target', 'Remove assignment', and 'Delete current row'.
'Show target' in the 'Data source' area of an assignment table

The following commands are available in the context menu of an element in the Data source area of an assignment table in Consolidation & Financial Planning:

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.

In Consolidation & Financial Planning, the Uses tab lists the elements that use the assignment table.

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

This content was generated using AI and reviewed by Lucanet subject matter experts before publication.