Chris1973
Member
Hello, Can anyone help on this question:
I would like to calculate a depreciation charge using the current NBV of an asset rather than R12855 going back to the start of the financial year. This is because we want to change the UEL of an asset mid year and for the future charges to be calculated using the current NBV of an asset.
e.g. £1200 asset with 12 month UEL.
Depreciation posted for first 6 months @ £100 per month.
Then change UEL to 24 months.
System then posts a credit into P7 effectively catching up to where it thinks it should be:
See below illustrative of what it is currently doing compared to what we would like it to do.
Period JDE Desired
P1 100 100
P2 100 100
P3 100 100
P4 100 100
P5 100 100
P6 100 100
P7 -250 33.33
P8 50 33.33
P9 50 33.33
P10 50 33.33
P11 50 33.33
P12 50 33.33
etc etc.
Any thoughts on how to do this?
Thanks in advance.
Chris
I would like to calculate a depreciation charge using the current NBV of an asset rather than R12855 going back to the start of the financial year. This is because we want to change the UEL of an asset mid year and for the future charges to be calculated using the current NBV of an asset.
e.g. £1200 asset with 12 month UEL.
Depreciation posted for first 6 months @ £100 per month.
Then change UEL to 24 months.
System then posts a credit into P7 effectively catching up to where it thinks it should be:
See below illustrative of what it is currently doing compared to what we would like it to do.
Period JDE Desired
P1 100 100
P2 100 100
P3 100 100
P4 100 100
P5 100 100
P6 100 100
P7 -250 33.33
P8 50 33.33
P9 50 33.33
P10 50 33.33
P11 50 33.33
P12 50 33.33
etc etc.
Any thoughts on how to do this?
Thanks in advance.
Chris