Example: Inverse Rates

The three records to be transferred to the transaction data table should have the following structure:

Fisc. year

Period

Posting date

Sales area

Sales

Currency

1995

001

1/5/95

B3Z

100

DEM

1995

001

1/5/95

A3F

200

DEM

1995

002

2/7/95

27A

200

DEM

 

The records are to be posted in USD to the transaction data table, which does not contain the posting day as a characteristic. The following possibilities arise:

  1. Translation on a specific date, e.g. 12/31/1994, using the bank buying rate.
  2. Example exchange rate is 0.7 USD/DEM.

    The records in the transaction data table then appear as follows:

    Fiscal year

    Period

    Sales area

    Sales

    1995

    001

    B3Z

    70

    1995

    001

    A3F

    140

    1995

    002

    27A

    140

    Sales of 350 USD for fiscal year 1995 will be displayed in the drill- down report. You can calculate this from the inverse exchange rate

    1 / (0.7 USD/DEM) = (1 DEM)/(0.7 USD)

    and get the value

    350 USD * (1 DEM)/(0.,7 USD) = 500 DEM

    i.e. the original amount.

    Note that, the reverse calculation always works if you have translated with an exchange rate unique to a specific date during the data transfer.

  3. Time-dependent translation at period end using the bank buying rate.
  4. The example exchange rate for this is:

    0.6 DEM/USD for 1/31/1995
    0.8 DEM/USD for 2/28/1995.

    The records in the transaction data table appear as follows:

    Fiscal year

    Period

    Sales area

    Sales

    1995

    001

    B3Z

    60

    1995

    001

    A3F

    120

    1995

    002

    27A

    160

     

    Sales of 340 USD for fiscal year 1995 are displayed in the drill- down report. If you chose the fiscal year and the period or, alternatively, the 7-digit Period 'yyyymmm' when defining the report, then you can also calculate the original amount from the inverse exchange rate. The drill down report works with the inverse period exchange rates

    1 / (0.6 USD/DEM) = (1 DEM)/(0.6 USD) and
    1 / (0.8 USD/DEM) = (1 DEM)/(0.8 USD)

    and calculates the value

    (60 USD + 120 USD) * (1 DEM) / (0.6 USD) + ( 160 USD) *
    (1 DEM) / (0.8 USD) = 500 DEM,

    i.e. the original amount.

  5. Time-dependent translation for the posting date using the bank buying rate.

Example exchange rates for this:

0.6 DEM/USD for 1/5/1995
0.8 DEM/USD for 1/9/1995
0.8 DEM/USD for 2/7/1995.

During data transfer the posting date will be ignored as this is not contained in the transaction data table as a characteristic. (see above)

The records in the data transfer table will then appear as follows:

Fiscal year

Period

Sales area

Sales

1995

001

B3Z

60

1995

001

A3F

160

1995

002

27A

160

 

Sales of 380 USD for fiscal year 1995 are displayed in the drilldown report. You cannot calculate the original amount using the inverse exchange rate, as the information about the translation date was lost during the summarization over posting date.

You can calculate the original amount approximately by translating the amount using the mixed specific date exchange rates or period end exchange rates. The latter would provide the following result:

(60 USD + 160 USD) * (1 DEM) / (0.6 USD) + ( 160 USD) *
(1 DEM) / (0.8 USD) = 566.67 DEM

that is, not the original amount of 500 DEM.