Adjust and Reclassify Values in Reporting Entities

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

Elements in Ledgers and Schedules

Functions in Ledgers and Schedules

Display in Ledgers and Schedules

Views in Ledgers and Schedules

Elements in Directory Structures

Reclassification of Profit or Loss from Previous Periods in Reporting Entities

Adjust and Reclassify Values in Reporting Entities

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

You can use the Adjust and reclassify values in reporting entities app to adjust and reclassify account values per reporting entity. For example, it is possible to:

Correct incorrect values at partner, cost center, and transaction type level

Reclassify account values from the general ledger or a subledger to a statistical ledger

Distribute values to several accounts

You can model the adjustments and reclassifications in freely definable scenarios with separate dimensions for the base values and the target postings.

The Adjust and reclassify values in reporting entities app can be created in any directory structure, provided that the element type Next Generation App has been enabled for this directory structure.

To create the app, proceed as follows:

Navigate to the directory structure under which you want to create the app.

Select the root folder of the directory structure or a folder under which you want to create the app, and select Create | App from the context menu.

The Create Next Generation App dialog is displayed:

Describes how to create a Next Generation app. — Create Next Generation app

From the App type drop-down list, select the app Adjust and reclassify values in reporting entities.

If necessary, change the name of the app.

Click Save to create the app and configure it as described below.

To configure the Adjust and reclassify values in reporting entities app, click the app in the tree view and click Edit in the displayed dialog.

Configure the steps as described below.

In the Settings step, specify the posting details and the relevant reporting entity. The step is displayed, for example, as follows:

This section describes the “Settings” step. — 'Settings’ step

Data level

Data level at which the reclassification is to be performed

Closed or archived data levels cannot be selected.

It is not possible to select closed or archived data levels.

Period

The app reads out the values from the selected period and reclassifies them within this period.

Reporting entity for which the values are to be adjusted and reclassified

In the Adjustment scenarios step, create the required adjustment scenarios. The step is displayed, for example, as follows:

This section describes the 'Adjustment scenarios' step. — Step 'Adjustment scenarios'

Option	Description
Scenario name	Unique name for the adjustment scenario
Description	Optional description of the adjustment scenario
Add row	Inserts a new empty row in the table to add another adjustment scenario

In the Basis and target step, specify the details for the adjustment and posting for each scenario. The step is displayed, for example, as follows:

This section describes the 'Basis and target' step. — Step 'Basis and target'

The following options are available in the Base value dimensions table:

Adjustment scenario for which the base value dimensions are to be defined

All scenarios that were defined in the Adjustment scenarios step can be selected.

Account or item whose values are to be used as the basis for the adjustment or reclassification.

If you select an item, the values of the underlying accounts are used.

Adjustment level(s) or adjustment level group whose values are to be used as the basis

Cost center(s) whose values are to be used as the basis.

The default All includes all cost centers assigned to the reporting entity selected in the Settings step.

Alternatively, you can select individual cost centers or cost center groups whose values are to be used as the basis. If you select a cost center group, all cost centers contained in the respective group are considered.

Partners whose values are to be used as the basis.

The default All includes all partners assigned to the reporting entity selected in the Settings step.

Alternatively, you can select individual partners or partner groups whose values are to be used as the basis. If you select a partner group, all partners contained in the respective group are considered.

Transaction type(s) in which the base values were posted.

The default All includes all transaction types assigned to the reporting entity selected in the Settings step.

Alternatively, you can select individual transaction types or transaction type groups as the basis. If you select a transaction type group, the values of all transaction types contained in the respective group are considered.

Period type of the base values. The following period types can be selected:

Transaction figure

Start balance of the period

End balance of the period

Adds a new row for another base record.

Description

Adjustment scenario for which the posting target dimensions are to be defined.

All scenarios that were defined in the Adjustment scenarios step can be selected.

Target account to which the adjusted and/or reclassified values are to be posted.

Adjustment level at which the target posting is to be performed.

Cost center at which the target posting is to be performed.

The default According to basis adopts the selection from the basis table.

Alternatively, you can select a different cost center to which the values are to be reclassified.

Partner to which the target posting is to be performed.

The default According to basis adopts the selection from the basis table.

Alternatively, you can select a different partner company to which the values are to be reclassified.

Transaction type for the target posting.

The default According to basis adopts the selection from the basis table.

Alternatively, you can select a different transaction type for the target posting.

Percentage factor for the adjustment; allows the values to be adjusted to a higher or lower percentage.

Defines whether debit values, credit values, or all values are considered.

Optional posting text for the created posting

Adds a new row for another target record.

The following options are available in the Posting target dimensions table:

As long as a step has not been fully configured and/or configuration errors exist, it is displayed with a red exclamation mark

Once a step is configured completely and without any errors, it is displayed with a green check mark

You can close the configuration dialog by clicking the arrow icon

at the top left.

To change the name of the app, select the app in the tree view and choose

Properties

from the context menu.

You can execute the Adjust and reclassify values in reporting entities app either separately

or together with other apps in an executable folder.

To execute the app separately, click Execute at the top right of the app's editing dialog:

Displays the editing dialog. The 'Execute' button at the top right of the dialog is highlighted in red. — 'Execute' button in the app's editing dialog

For better organization, you can create as many folders as you like in a directory structure.

You can group multiple apps together in folders and execute them together. Proceed as follows:

Ensure that, in the workspace configuration, the object type Folder for the directory structure has been enabled.

In the tree view, select the element under which you want to create the folder and choose Create | Folder from the context menu.

In the Create folder dialog, enter a Name and select a desired Behavior if there should be an error during execution of the folder:

Continue execution

Cancel execution

Save the executable folder.

Paste the apps to be combined into the folder. Choose one of the following options:

Add existing apps using the context menu commands

Cut

and

Paste

Create new apps in the folder using the

Create

context menu command.

Execute the folder and all elements contained in it by clicking Execute all subordinate elements in the detail view of the folder:

Combining apps and executing them together

On the Created elements tab, the postings that were created during the app execution are shown.

The table provides the following information:

Type

of the element

Path

under which the element was created. When you click on the link, you are taken directly to the posting in the relevant

journal

or to the report.

Date of the

last execution

that created the element

This is the tab 'Created Elements' — Tab 'Created Elements'

If necessary, you can delete all elements.

Note: Once all elements have been deleted, the state of the wizard is Not executed again.

The App properties are displayed on the tab of the same name:

Shows the 'Properties' tab of a consolidation app — 'Properties' tab

The following App properties are displayed:

Type

of the element

Function of the

App

Version

of the element.

New available version

As soon as a new version of the app is available that contains changes to the app configuration and/or the calculation logic of the app, the Refresh command is displayed, allowing you to update the app to the latest version.

Information about the changes to each version can be found in the Release Notes, which can be accessed via the link of the same name.

We strongly recommend to update all apps to the new version as soon as possible because it cannot be guaranteed how long an app with an obsolete version can be executed.

Last updated on Aug 16, 2023

Adjust and Reclassify Values in Reporting Entities

Overview

Creating the 'Adjust and Reclassify Values in Reporting Entities' App

Configuring the 'Adjust and Reclassify Values in Reporting Entities' App

Executing the 'Adjust and Reclassify Values in Reporting Entities' App

Displaying and Deleting Created Elements

Displaying the App Properties

Adjust and Reclassify Values in Reporting Entities

Overview

Creating the 'Adjust and Reclassify Values in Reporting Entities' App

Configuring the 'Adjust and Reclassify Values in Reporting Entities' App

Settings

Posting

Reporting entity

Adjustment scenarios

Basis and target

Scenario

Account or item

Adjustment level

Cost center

Partner

Transaction type

Period type

+ Add row

Option

Scenario

Account

Adjustment level

Cost center

Partner

Transaction type

Factor

Debit/Credit

Posting text

+ Add row

Executing the 'Adjust and Reclassify Values in Reporting Entities' App

Executing an app separately

Combining Apps and Executing Them Together

Displaying and Deleting Created Elements

Displaying the App Properties

Table of Contents

Company

Legal Notice

Table of Contents

Related Articles

Company

Legal Notice