Fixed Assets - EBS (MOSC)

MOSC Banner

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".

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center