Translating Asset History Sheets Using the Spot Rate 

A problem occurs if the fixed assets are not translated historically but by means of the spot exchange rate: an arithmetically-consistent development is generated from the closing balance of the previous year to the closing balance of the current period. Here, the closing balance of the previous year is valuated using the spot exchange rate of the previous year, all other values are calculated using the new spot rate of the current period. This causes a difference which equates to the translation difference between the closing balance of the previous year and the opening balance of the current year. This difference can be shown by means of a special transaction type when posting the translation differences and in a specific report.

The following settings must be made:

The translation difference is posted to the new APC transaction type (for example 105).

The difference is posted to the new transaction type for accumulated depreciation (for example 205).

The difference is posted to a translation difference item.

The transaction type group for the opening balance was translated using the spot exchange rate of the previous year.

Transaction type group which contains the translation differences for the opening balance.

Transaction type group which is calculated as the total of the transaction type for the opening balance and translation differences.

Normal transaction type group which is calculated from the translation using the current spot exchange rate.

Transaction type group which is calculated as the total of the transaction types for the opening balance and for the current year.

The system settings for generating an asset history sheet that includes translation differences are shown below; these are based on the standard SAP system.

Transaction types/transaction type groups

Text

TTy/TTy group

Formula

Opening balance APC

100

 

Opening balance accumulated depreciation

200

 

Translation differences APC

105

 

Translation differences - accumulated depr.

205

 

Opening balance APC + translation diff.

109

100 + 105

Open.bal. accumulated depr. + translation diff.

209

200 + 205

 

Translation method definition

Meth.entry

Item set / trans.type set

ExRt ind.

Trl.key

FS item

TTy

1

Item set ‘tangible assets’

4

1

 

105

 

TTy set ‘opening balance APC’

       
           

2

Item set ‘tangible assets’

4

1

 

205

 

TTy set ‘opening balance accumulated depreciation’

       
           

3

Item set ‘tangible assets’

1

1

2017 0100

 
 

TTy set ‘others’

       

 

Resulting asset history sheet

 

PY clos.bal.

Transl.diff.

Open.bal.

Acquisitions

...CB

APC

100

105

109

120

...

Accumulated depreciation

200

205

209

220

...

 

Legend

Exchange rate indicator

1

spot rate

Exchange rate indicator

4

previous year spot rate

Translation key

1

translation using the period end rate

FS item

2017 0000

currency translation differences