SLM depreciation taking into account revaluation and unplanned depreciation

[Former Member]

Hi Experts,

I am looking for some suggestions on the appropriate way to configure a depreciation key that calculates on a straight line based on the useful life of the asset, with base calculation being the acquisition value and taking into account value adjustments or unplanned depreciation.

If I have an asset capitalized on 01.01.2017 with an acquisition value of 10,000 and a useful life of 10 years. I would like depreciation of 1,000 until 2027. However, if there is unplanned depreciation in next year of -1,000. I would like the system to recalculate the depreciation so that the full useful life is realized.

Currently, my custom key calculates based on the original acquisition value and does not recalculate when there are any value adjustments.

I am using multilevel method 1, remaining life indicator not ticked.

Which are the correct settings to achieve the desired results?
Thank you for any suggestions;

Edit: Title was misleading

[Former Member]

Hi Bernhard,

Thank you for your time,

I think I over complicated my requirement somewhat, my key is working fine for the most part. However I would like the key to take into account revaluations and unplanned deprecation and other postings that may occur during the useful life. Whereas currently, my key takes Acquisition value / useful life and does not recalculate when there are negative posting, such as unplanned depreciation.

For example, Acquisition value of 1,000 over 10 years useful life. Asset will depreciate fine as expected, 100 over 10 years.

However, for more complex assets, should there be an adjustment of -500 in the second year of useful life, the key will still take 1,000 / 10 = 100 and therefore the asset will be fully depreciated by 5 years, and the full life not realized.

There are some period control settings for unplanned depreciation and revaluations, should I be activating these settings for example 'start of the year'.

Thanks again

[former_member205041]

Hi,

please go to transaction AFAMA. Here you see a lot of depreciation keys with you requirements.

Tip.: If you go to the fields in the depr. key and press F1 you see which tables are involved. This gives you a good overview.

Example:

Table T090NS: check which multilevel method (METSTU) has base value 01 Acquisition value

Table T090NR: Check which base method (AFARSL) has "percentage from useful life"

Table T090NAZ: Check which depreciation key (AFASL) you have in your chart of depreciation (AFAPL) with the required

multilevel method (METSTU) and base method (AFARSL).

best regards

Bernhard