A. Customizing

Define method

Method with validation rule

To define a validation method, go to the process view of the workbench and choose Consolidation Functions ® Validation ® Method

Select the entry Method and choose Display in the context menu.

In the lower left screen area, choose Create from the context menu.

Create a method with:

The technical nameValMD

The nameValidate Reported Financial Data

Data stream type Totals Records

Validation type Data Rows Are Totaled

Below the method, create the validation rule : Total Assets = Total Liabilities.

Assign the technical nameASSETLIABNow the validation rule is reusable and appears in the list of validation rules when you go to the process view of the workbench and choose Consolidation Functions ® Validation ® Validation Rule

Selection condition

Create a selection condition as follows:

Choose Create Selection Condition   in the work area of the workbench, in the selection area.

For the first selection, assign the titleTotal Assets

To select the characteristic Item , choose Insert Characteristic .

Select the total assets item from the consolidation chart of accounts.

Proceed in the same manner for total liabilities :

The system displays the selections in the work area.

Save your changes.

Formula

You create the formulaVAL_PER( total assets ) + VAL_PER( total liabilities ) = 0. (Total liabilities are added to total assets because the system stores liability items with a negative sign.) Proceed as follows:

Place the cursor in the formula editor.

In the function list, double-click the function VAL_PER .

If necessary, place the cursor inside the bracket, and double-click the selectionTotal Assetsin the list of selections.

Select the operator "+".

In the function list, double-click the function VAL_PER .

If necessary, place the cursor inside the second bracket, and double-click the selectionTotal Liabilitiesin the list of selections.

Select the operator "=".

Choose Number and enter “0” (zero) .

Save your changes.

Message

Go to Message Maintenance (transaction SE91) and create a message class and the following two messages:

One message for when the rule total assets = total liabilities is true. Specify the message textTotal assets equals total liabilities

One message for when the rule total assets = total liabilities is false. Specify the message textTotal assets does not equal total liabilities

Now return to the workbench and proceed as follows:

To create the message for the positive result, select the true node and choose Create Message in the context menu.

The system creates a node for the message.

In the work area, specify the message number, the message class, and the message type (in this case, "Success" (S)).

Save the message.

Proceed in the same manner for the negative result. In this case, use the message type “Error” (E).

Define Task

To define a validation task, go to the process view of the workbench and choose Consolidation Functions ® Validation ® Task

Select the entry Task and choose Display in the context menu.

In the lower left screen area, choose Create from the context menu.

Specify a technical name, a short text, and a medium text for the task.

In the group field Values, choose all of the following options:

Reported financial data

Local currency

Select the period category the represents annual consolidation.

To assign the method, choose Independent of Consolidation Unit .

Assign the method (you previously created) to the task.

Choose Save Log.

Save the task.

B.Execution of the Validation

Prerequisite: The task is assigned in a task hierarchy.

Execute the validation task in the consolidation monitor.

Place the cursor at the intersection between the task for validating reported financial data and the top consolidation group .

Choose Update Run .