Custom Formula Depreciation Method in Fusion Assets 20C
We have a need to define an 8 yr depreciation method that sets the annual depreciation rate for each of the 8 years as follows:
First 12 months from the in-service date (or prorate date) = 0%
Next 12 months = 0%
Next 12 months = 20%
Next 12 months = 25%
Next 12 months = 40%
Next 12 months = 5%
Next 12 months = 5%
Next 12 months = 5%
We have tried using the following formula depreciation method:
Decode(Round(<Remaining life 1> + .4,0),8,0,7,0,6,.2,5,.25,4,.4,.05)
However, with a current depreciation period of Oct-20 we added two assets with this formula, one with an in-service date of 2/1/2016 (prorate 3/1/2016) and another with an in-service date of 8/1/2016 (prorate date 9/1/2016). Both assets calculated the same cath-up depreciation amount, as if the start date of 1/1/2017 was used for both assets when determining "remaining life 1".