Creating and Configuring References

Getting Started

Global Functions

Lucanet Lume

Data Hub

Administration

Extended Planning & Analysis (xP&A)

Consolidation & Financial Planning

User Interface of Lucanet Consolidation & Financial Planning

General Functions

Basic Configuration

Dashboards

Reporting & Analyzing

Elements in Ledgers and Schedules

Creating and Configuring Items

Creating and Configuring Accounts

Creating and Configuring Formulas

Creating and Configuring Total Lines

Creating and Configuring References

Show Postings

Functions in Ledgers and Schedules

Display in Ledgers and Schedules

Views in Ledgers and Schedules

Elements in Directory Structures

Creating a Postings Report

Import and Journals

Planning

Consolidation

Dimensions

Excel-Integration

Workspace Configuration

ESG Reporting

Disclosure Management

XBRL Tagger

Lease Accounting

Banking & Cash Management

Data Collection

Tax Compliance & Reporting

Glossary

Last modified on 20.06.2024

References are links that refer to items or accounts in general ledgers, subledgers, and statistical ledgers. References can be used to create derived structures in Lucanet (e.g. a derived IFRS balance sheet). A distinction is made between direct and indirect references.

direct reference

always contains all subordinate items and accounts of the default item. If a change is made within the structure of the default item, this change will also be applied to the reference.

In contrast, an

indirect reference

allows exceptions to be defined for the display of the subordinate items and accounts.

To create a reference:

Mark the item or account for which a reference is to be created.

Right-click the name of the item or account and choose Copy from the context menu.

Open the ledger or schedule into which the reference is to be pasted.

Right-click the name of the item under which the reference should be added, and choose Paste as reference from the context menu.

Context menu command 'Paste as reference'

The item or account, including all subitems and subaccounts of the original structure, is pasted under the desired item. Each item and each account that is a reference is marked with an arrow pointing to the right:

Items or accounts can be pasted as references in a

schedule

only if the items or accounts in the ledger are assigned to the correct transaction type category.

references can be pasted under items with an

activated debit/credit shift

To configure a reference:

Navigate to the desired reference.

Right-click the reference and choose Properties from the context menu.

The following options are available:

The General tab is displayed as follows, for example:

The 'General' tab is displayed in the 'Reference properties' dialog. — 'General' tab in the 'Reference properties' dialog

The following properties and options are available on the General tab:

Option	Description
Type	Element type
OID	Object identifier for the element that is automatically generated when creating the element
Reference source	Shows the referenced item or account
Reference name	Name of the reference
Reference type	- Direct reference to the selected item or account — This is the default type. Direct references contain all subordinate items and accounts of the referenced item. If a change is made within the structure of the referenced item, this change will also be applied to the reference. - Indirect reference to all child items and accounts — Indirect references do not have to contain all subordinate items and accounts of the referenced item, because individual items and accounts can be removed from the display (see Child elements tab).
Display child elements	The check box can be deactivated if no child elements are to be displayed.
Multiply value by -1	All values of the original item or original account are multiplied by -1 to display the reference.
Formatting	Formatting options for display: Font color, background color, icon and if the element is to be formatted bold.

The Transaction type tab is displayed as follows, for example:

The 'Transaction type' tab is displayed in the 'Reference properties' dialog. — 'Transaction type' tab in the 'Reference properties' dialog

If necessary, change the permitted transaction types for indirect references. The following options are available:

Option	Description
All	All transaction types of the item or account for the reference are permitted.
Individual	Not all transaction types of the item or account for the reference are permitted.

The Transaction type tab is displayed only if the transaction type can be changed.

The Child elements tab is displayed as follows, for example:

The 'Child elements' tab is displayed in the 'Reference properties' dialog. — 'Child elements' tab in the 'Reference properties' dialog

Which direct child elements of the reference element are not to be displayed in the reference can be defined on the Child elements tab. Furthermore, the names of the child elements can be edited. The following columns are displayed in the table:

Column	Description
Original name	Name of the original element
New name	The name of the original element can be overwritten in the New name column.
Exceptions	If the Do not reference check box is activated, the element will not be displayed in the reference.

The child elements can be edited only if the option Indirect reference to all child items and accounts is chosen under Reference type on the General tab.

The Number format tab is only displayed for references in statistical ledgers.

The Number format tab is displayed as follows, for example:

The 'Number format' tab is displayed in the 'Reference properties' dialog. — Number format' tab in the 'Reference properties' dialog

On the Number format tab, the way numbers are displayed can be configured differently from the display settings. The following options are available:

Option	Description
Apply number format	Applies the number format that is different from the display settings
Number display	Formatting of the displayed values
Decimal places	Number of displayed decimal places