The app Adjust and reclassify values in consolidation areas allows you to selectively adjust and reclassify account values for each consolidation area. The app supports the following use cases, among others:

  • Correcting errors in values at the partner, cost center, and transaction type levels
  • Reclassifying account values from the general ledger or subledger to a statistical ledger
  • Allocation of values across multiple accounts

To configure the app Adjust and reclassify values in consolidation areas, click the app in the structure view and click Edit in the displayed dialog.

Then configure the steps as described below.

In the Settings step, specify the general settings for the configuration:

This is the description of the step 'Settings'.
Step 'Settings'
OptionDescription
PostingPeriod for which the values are to be adjusted or reclassified
Consolidation areaSelection of the consolidation area for which the values are to be adjusted or reclassified

In the Adjustment scenarios step, create the required adjustment scenarios.

This is the description of the step 'Adjustment scenarios'.
Step 'Adjustmen scenarios'

Unique name for the adjustment scenario

Used for identification and reference in the Basis and target step.

Optional description of the scenario

Used for documenting the purpose or the adjustment logic.

Adds a new empty row to the table to add another adjustment scenario

In the Basis and target step, specify the base value dimensions to be adjusted or reclassified as well as the posting target dimensions for each scenario.

This is the description of the step 'Basis and target'.
Step 'Basis and target'

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

Adjustment scenario for which the dimensions of the base values are to be defined

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

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

If an item is selected, the values of the underlying accounts are used.

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

Consolidation unit(s) that contain the base values

The default setting All includes all consolidation units that are contained in the consolidation area selected in the Settings step.

Alternatively, you can select individual consolidation units whose values are to be used as the basis.

Partner company or companies whose values are considered as the basis

The default setting All includes all partner companies that are assigned to the consolidation area selected in the Settings step.

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

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

The default setting All includes all transaction types that are assigned to the consolidation area selected in the Settings step.

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

Selection of the period type of the base values:

  • Transaction figure
  • Start balance of the period
  • End balance of the period

Adds a new row for an additional base data record

Description

Adjustment scenario for which the dimensions of the target values 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 posted

Adjustment level on which the target posting is made

Consolidation unit for the target posting

The default setting According to basis applies the selection from the base table.

Alternatively, you can select a different consolidation unit to which the values are to be reclassified.

Partner company for the target posting

The default setting According to basis applies the selection from the base table.

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

Transaction type for the target posting

The default setting According to basis applies the selection from the base table.

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

Percentage factor for the adjustment (default value: 100%)

Allows the values to be adjusted to a higher or lower percentage

Specifies whether debit values, credit values, or all values are considered (default value: All)

Optional posting text for the generated posting

Adds a new row for an additional target posting

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 app Adjust and reclassify values in consolidation areas either separately, together with other apps in an executable folder or as part of consolidated financial statements.

How to proceed in each case is described under Executing the Consolidation.

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.
  • Date of the last execution that created the element
This is the description of the tab 'Created elements'.
Tab 'Created elemens'

If necessary, you can delete all elements.

Note: Once all elements have been deleted, the state of the app 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.