Adjust and Reclassify Values in Reporting Entities

Overview

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.

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

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.

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

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

Option

Description


Posting

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

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:


Option

Description


Scenario

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

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

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


Cost center

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.

 


Partner­

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

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

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

+ Add row

Adds a new row for another base record.


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


Option

Description


Scenario

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.


Account

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


Adjustment level

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


Cost center

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­

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

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.


Factor

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


Debit/Credit

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


Posting text

Optional posting text for the created posting


+ Add row

Adds a new row for another target record.


  • 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.
Executing the 'Adjust and Reclassify Values in Reporting Entities' App

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:

  1. Ensure that, in the workspace configuration, the object type Folder for the directory structure has been enabled.
  2. In the tree view, select the element under which you want to create the folder and choose Create | Folder from the context menu.
  3. 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
  4. Save the executable folder.
  5. 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.
  6. 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
Displaying and Deleting Created Elements

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.

Displaying the App Properties

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.

Contact Us