We have a particular requirement for Brussels region we want the depreciation of asset to be calcula
Requirement
----------------------------------------------------
Use
WDV method with defined rates until the asset is depreciation half to the cost;
after that SLM method will be used.
Example
------------------------------------------------------
Asset
cost =100
WDV
will be for 1.75 months and then it will be SLM for remaining period
Formula
used = DECODE(SIGN(<Remaining Life 1> - 3.25), 1, 0.4, 0, 0.4, -1, 0.2)
Solutions tried
----------------------------------------------------
I
tried three different setups of depreciation calendar, prorate convention and
divide depreciation but the results in every setup is same
1.
Depreciation calendar = Daily , Prorate Convention = Daily, Divide depreciation
= Daily
2.
Depreciation calendar = Monthly , Prorate Convention = Daily, Divide
depreciation = Daily
3.
Depreciation calendar = Monthly , Prorate Convention = Monthly, Divide
depreciation = Daily