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 |