Scenario when Using Offline Data Entry 

Purpose

This scenario applies if at least one company or consolidation unit transfers its data by means of the offline PC data entry program on the basis of Dbase (FI-LC) or Microsoft Access (FI-LC and EC-CS).

Process Flow

Data entered in the offline PC data entry program using Dbase and Access are not converted during the changeover of the Consolidation application, although you can convert them indirectly to some extent.

Dbase

Case 1: Decentralized data entry in euros after changeover of R/3 Consolidation

In order to enter new financial data, you need to assign the new local currency key ‘euro’ for a company in the data entry program.

To do this, you download master data from the R/3 System and import it into the data entry program.

Case 2: Decentralized data entry in euros before changeover of R/3 Consolidation

It no be possible to wait until R/3 Consolidation is changed over before entering data. In order to enter data offline in euros before the R/3 System is changed over, you can temporarily set the local currency key of a company to ‘euro’ for the download.

Note that in this case you cannot use comparison values or carryforward values from the prior year.

Microsoft Access

Changeover of local currency key

In order to enter new financial data, you need to assign the new local currency key ‘euro’ for a company in the data entry program.

To do this, you download master data from the R/3 System and import it into the data entry program.

It no be possible to wait until R/3 Consolidation is changed over before entering data. In order to enter data offline in euros before the R/3 System is changed over, you can temporarily set the local currency key of a company to ‘euro’ for the download.

Note that in this case you cannot use comparison values or carryforward values from the prior year.

Download and import of converted financial data in R/3

You can download financial data transferred to R/3 from decentralized data entry, and import it back into the offline program.

This function enables you to transfer euro values into the offline program after changing over local currency in R/3 Consolidation. You can thereby analyze past values and use comparison and carryforward values as a reference when entering data for the current fiscal year.

You download and import data for a particular year and consolidation unit (company in FI-LC, group of consolidation units in EC-CS). Local valuation data and standardizing entries in local currency are downloaded.

Entry of additional financial data (FI-LC)

As of Release 4.0B, you can also enter additional financial data required for the elimination of intercompany profit/loss and for the consolidation of investments.

Additional financial data for the elimination of intercompany profit/loss can be transferred in the same way as other financial data, by downloading it from the R/3 System and importing it into Access. This function is not available for additional data relevant to consolidation of investments, however.

Entry in group currency (EC-CS)

In order to enter data in group currency, you need to transfer the ledger currency (which may have been changed over) and the exchange rates by downloading master data from the R/3 System and importing it into Access.

Reporting

Use of Microsoft Excel (FI-LC)

If you use Excel in addition to Access for entering data and creating reports, you can transfer values in euros from Access to Excel.