Custom Depreciation Rate Table
The Rule of depreciation on vehicles is the following:
5 years 0 months
3% of cost for months 1 – 12
2.5% of cost for months 13-24
1% of cost for remaining months until NBV=0
We use daily prorate convention, so we have 365 pediods per year - over 1800 total
When we try to set up the rates table in Oracle, the system is requiring the sum of all years rates for each period to add up to 1 if it is cost based or if it is NBV based the last year rate should be 1. Neither is satifying the client's requirement.
Do you have a suggestion on how to handle this or if there is a workaround ?
0