Quering Values

The abbreviation defines from where the data to be read in are derived. The following abbreviations are allowed:

The Data level parameter specifies in which data level the data to be read in are contained. Data can be located in the actual data level and in any number of planning data levels. To specify data levels:

The adjustment level or adjustment level group parameter specifies the adjustment level or adjustment level group to which the values to be imported are posted and evaluated. The default adjustment level is Data imports. To specify adjustment levels or adjustment level groups:

The parameter Organization element specifies the reference to the reporting entity, cost center, cost center group or organization group from which the values are to be read. Specify organization elements as follows:

The parameter Account or Item specifies the name of the account and item whose value you want to export. To specify accounts or items:

The parameter Periodicity specifies the frequency with which the values are read from Lucanet. The following periods are allowed:

Example: Export of values for 31/12/2017. The possible periodicities return the following:

The StartDate specifies the value for the month, quarter or year in which the date falls. The entry must be made in the format DD/MM/YYYY . This is regardless of the formatting of the view in MS Excel. When entering the date 31/12/2017, for example, the view format could be Dec. 2017.

Note: Instead of a specific entry, you can also use MS Excel to apply absolute or relative cell references, such as A2 (relative) or $A$2 (absolute) and references to named cells (see the following examples).

When querying values, the optional parameter transaction type can be added to the LUCANET formula. By default, for values from the financial sector, the balance at the end of the period is always exported to MS Excel. When using the optional parameter Transaction type, it is also possible to query other values (e.g. the balance at the start of the period).

Note: If the parameter Transaction type is not specified when querying parameter values, account balances are always exported.

A Lucanet formula querying the transaction type must be set up as follows:

The following parameters for transaction type are available:

If fixed asset schedule, provision schedule, loan schedule, and/or statement of changes in equity are set up in Lucanet, you can also query information (in addition to the default parameters) from these categories. The following parameters are available:

When querying values, the optional parameter EndDate can be added to the LUCANET formula. You can use this parameter, for example, if you want to read in the cumulated values of a specific period from the P&L to MS Excel. The value read in is then the total of values between the start and end date.

The LUCANET formula must be set up as follows:

When querying values, the optional parameter Partner or Partner group can be added to the LUCANET formula. You can use these parameters to query partner information.

The LUCANET formula must be set up as follows to query partner information:

By default, values from Lucanet are read in to MS Excel in the default currency. The Display currency and Transaction currency parameters can be used to define which values are to be read in to MS Excel and in which currency.

To query values in a currency other than the default currency, the LUCANET formula must be set up as follows:

The result of a query depends on the parameters used in the Lucanet formula. The following variants are available:

The YTD parameter can be used to query the value of an account or an item from a Year-To-Date period up to a requested period.

The LUCANET formula must be set up as follows:

Explanation: XX represents a period

Examples: