﻿ Example: Inverse Rates (CA Drill-Down Reporting)

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.