Manual Data Entry of Additional Financial Data 

Use

Additional financial data is required for performing:

·        Historical currency translation

·        Elimination of interunit profit/loss in inventory

·        Consolidation of investments

Additional financial data is required in addition to the data in the totals database (that is, in addition to balance sheet, income statement, and similar data). Depending on its use, additional financial data consists of:

·        Group share information with historical valuations
-> for historical currency translation

·        Data on changes to investments, changes to equity, equity holding adjustments, changes to goodwill, changes to fair value adjustments, and information regarding the sequence of activities
-> for consolidation of investments

·        Data on group-internal sale of goods and services (thus, inventory and supplier data), and data on product groups
-> for the elimination of IU profit/loss in inventory

Integration

With validation you can compare the monetary values of the additional financial data with those in the totals database.

Prerequisites

In the data basis you created or had the system automatically generate InfoCubes and/or ODS objects for the data streams to be used to record additional financial data (for example, ODS objects for supplier and inventory data).

You have finished all customizing settings for all consolidation functions you will use for recording additional financial data—this can include:

·        Elimination of interunit profit/loss in inventory (particularly for product groups and inventory items)

·        Consolidation of investments

Concerning elimination of interunit profit/loss in inventory, if you want to record inventory data as additional financial data (instead of totals data), then you have selected the additional financial data option for the location of values in the respective task.

Concerning consolidation of investments, if you want to record additional financial data, then you have selected the following options (in the workbench under Consolidation Functions ® Consolidation of Investments ® Settings ® Location of Values on the General tab page at Location of Values):

·        Read Investment Data From = Additional Financial Data

·        Read Equity Data From = Additional Financial Data or (alternatively) Totals Database and Additional Financial Data

Features

You can manually record additional financial data:

·        For the elimination of interunit profit/loss in inventory:

¡        Inventory data

¡        Supplier data

·        For the consolidation of investments:

¡        Goodwill

¡        Sequence of activities

It is not yet possible to record additional financial data for the changes in investments or changes in equity, which are needed for historical currency translation.

Consolidation monitor and status management

You execute the data collection task for additional financial data (and other financial data) in the consolidation monitor.

You can collect additional financial data for a single consolidation unit or for a consolidation group. Since goodwill is group-dependent, you run the collection of goodwill for a consolidation group.

Additional financial data must be collected directly subsequent to the collection of reported financial data.

Activities

A. Customizing manual entry of additional financial data

Defining data collection method

In a data collection method you specify which additional financial data you want to record with the data entry task.

...

       1.      In the process view of the workbench, choose Consolidation Functions ® Data Collection ® Data Collection Method. Choose Display in the context menu.

       2.      In the lower left area of the workbench, create a new data collection method or change an existing one.

       3.      In the screen for data collection methods, specify which additional financial data is to be recorded.

...

                            a.      Add a new row to the table using the Insert symbol.

                            b.      Select a data stream for additional financial data (for example, inventory data and supplier data).

                            c.      For each of these data streams choose Online Data Entry as the data collection procedure.

                            d.      Save the data collection method.

See also section Data Collection Method.

Define Task

...

       1.      In the process view of the workbench, choose Consolidation Functions ® Data Collection ® Task. Choose Display in the context menu.

       2.      In the lower left area of the workbench, create a new task or change an existing one.

       3.      Specify the required data In the task screen. When doing so, choose the data collection method in group box Assign Methods. (You need to have already created the data collection method.)

       4.      Save the task.

See also:

·        Task

·        Task Sequence

B. Entry of Additional Financial Data

...

       1.      Run the consolidation monitor.

       2.      Start the task for entering additional financial data, for one consolidation unit or one consolidation group, in update mode.

       3.      In the following data entry screen, select which additional financial data you want to enter (for example, supplier data). Then choose Change.

       4.      In the next screen, Additional Financial Data: <type of data>, double-click on the consolidation unit for which you want to record data.

       5.      In the next screen enter the required data, and save it.

       6.      Repeat the same procedure for other consolidation units.