Sometimes it happens to my customer that they receive invoices they would like to include in the acquisition value (and depreciation base) after they have activated and depreciated an object for a period of time. They normally process those additional invoices as “additional investments”. The problem we have is that subsequent depreciation is not taking into account that the remaining life time is shorter. This leads to a lump sum depreciation an the end of life. My customer would like to depreciate the original acquisition value + additional value - accumulated depreciation evenly over the remaing life time.
Any help highly appreciated.
Example:
Acquisition value: 12000
Life: 1 year
Additional investment after two months of depreciation: 6000
Page 1 / 1
IN IFS there are several pre-defined depreciation methods, I would assume you can find one that is named REM AP, Rem Value Rem Life, Assigned Period with the method type RemValue/RemDays.
If there is no such depreciation method in your installation of IFS APPS then you can make one. The method type RemValue/RemDays is what you need to select to get the depreciation you are looking for. For the starting principle I would select Beginning of period. For depreciation Rate Type I would select Divided by life.
/Jonas
Hi Jonas, I still can’t get this to work. See examples below.
I still get a bigger depreciation amount the last period.
Am I doing something wrong?
/Johan
Example 1 - Alternative Life
Example 2 (Estimated Life)
Hi johant,
I must have misunderstood your requirement. With the depreciation method I proposed you get to keep the depreciation length, i.e. the added investment does not prolong the life of the asset.
Am I getting it right that the added investment is expected to prolong the life of the asset?
In your example 2, could you please explain how you get all the different depreciation values after the added investment,
in period 3 you get 1525,
in period 4 you get 1475,
in period 5 you get 1525 again,
in period 6 you get 1475.
It seems there are other issues to address before we can come to a conclusion on how to get the depreciation method right.
Hi,
Please take a look at the right column of the table in my original posting.
I buy something for 12000 and specify that it should be depreciated over 12 months.
I depreciate the object 1000 in January and 1000 in February.
I add 6000 to the acquisition value
I now want the remaining book value (12000-1000-1000+6000=16000) to be depreciated over the remaining life (10 months). I.e. 1600 per month.
(The reason I got different values when I tested your set-up was most likely because I used RemValue/RemDays)
/Johan
Did you try to alter the depreciation Method Type to RemValue/RemMonths or RemValue/RemPeriods?
And did you try to alter the change Base Value from Depreciation Year to Depreciation Period?
Best regards
Jonas
Yes, I have tested different settings for those parameters, but I always end up with a bigger depreciation amount for the last period. /Johan
I have no more clues. As far as I recall we got it right in a database I unfortunately have no access to now. Try to bugreport your issue.
Thanks for trying to help out!
/Johan
Today I tested the process at a customer on IFSAPPS 10 UPD 11 and it works as you seem to need it to. The last depreciation amount is taking care of the total of rounding differences, i.e. a very small deviation from the line of depreciations. This is the set-up of the depreciation method:
Thanks! Did you use this method all the way from the beginning or did you switch from straight line to this one when you added the extra investment?
I have tested the set-up you suggested and it seems to work exactly the way I want.
