This question has been flagged
2 Replies
8408 Views

Hi all, anyone has an idea to use Asset module(Version7)?

What the effect i need is: Linear computation

First depreciation date is same as purchase date

First depreciation amount to last depreciation amount are all same and equal to asset amount/number of depreciation

How to configure properly to get this effect as above? hope my question is clear, thank you very much!

Avatar
Discard
Best Answer

To get the effect of 'first depreciation date is same as purchase date', you must check Prorata Temporis because it will indicates that the first depreciation entry have to be done from the purchase date instead of the first period/fiscal year.

Since you choose the linear computation method, the amount will all be the same from the first depreciation until the last depreciation, because the linear computation will divide total amount depreciation with number of depreciation equally.

Avatar
Discard
Author

Thanks Viktor Aditya with your comments, but same problem as I revert to Naresh as above.

Brenda, I am looking for the same functionality but its seems openerp guys hadn't fully implemented asset management concepts. Also, setting up depreciation opening entries is a pain.

Best Answer

Hi Brenda,

If you want your first depreciation date is same as purchase date then you need to have the boolean Prorata Temporis checked. For equal computation use method linear

Note: You want have the equal amount when " Prorata Temporis checked.Reason is the calculation is done on days. Means the First depriciation amount will be splitted between First and last year.

For eg: Your purchase date is 18/04/2013 then the amount will be deducted from first depreciation value for 107 days approx i.e (1/1/2013-17-04-2013)and will be calculated for 18/04/2013-31/12/2013 for first year. Say you have 600000 as deprecation amount for 3 yrs. So 600000/3 = 200000 so each year you have 2 lakh as amount to be depreciated. So in this case you will have 200000-(200000/365)107 as first depreciation amount.for second and third you will have 2 lakh for the last is remaining one i.e (200000/365)107

Prorata Temporis

computation

Hope this helps !

Thanks,

Avatar
Discard
Author

Thanks Naresh Soni, from your screen shot I can read clearly, but the purchase date is 04/18/2013 and depreciation date is 01/01/2013, how can it become at least 04/01/2013 automatically though I can try do modify it by myself?

Sorry I attached the old screen shot ! Let me update the screen. But the point is you need to use "Prorata Temporis " for this requirement

Author

Thanks Naresh Soni, Could you let me know did you edit the depreciation date by yourself or the system give you automatically the good date? Thanks!

yes system gave me ! Actually first screen I didn't had that boolean checked then I checked and recomputed my depreciation ! Why its simple don't you get the same result ?

Author

I did exactly what you showed in screenshot, but the result you and me got is no good current depreciation amount(not always 1666.67), strange, you see i need good depreciate date and good same depreciate amount! 04/18/2013 0.00 1173.52 3826.48
04/18/2014 1173.52 1666.67 2159.81
04/18/2015 2840.19 1666.67 493.14
04/18/2016 4506.86 493.14 0.00

Hi Brenda, I checked and it's not a bug but the working is different. I have updated my original answer to explain.

Author

Thanks Naresh for your clear explanation, if so, it implies there is no a configuration way to make effect like 1. depreciation date = purchase order date 2. equal depreciation amount (show like 04/18/2013 1666.67,04/18/2014 1666.67,04/18/2015 1666.67) by current provided asset model together? Or there is still a way to do it? what do you think? Thanks!

Hi Brenda, nope, there is no way to configure as you want. Because the way asset works is opposite then what you want. May be you can customize it to achieve this at your end.

Author

Thanks Naresh, then nothing to do at the beginning, but only do some adjustments before post the journal entry, like combine the split depreciation amount onto first deprecation date then delete the last one...

:-D ya that's a workaround or even have that boolean untick and just correct the dates