web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

Wrong Depreciation Amount after Revaluation

(2) ShareShare
ReportReport
Posted on by 37
We have a building that was constructed and placed into used last Feb 2020 with a useful life of 20 years (240 months). The capitalized cost was CU 24,000,000 and no residual value was set. The monthly depreciation is CU 100,000
 
On April 30 2025, the carrying amount of the building is CU 17,700,000 (CU 24M less accumulated depreciation of CU 6.3M). The new appraised value on May 01, 2025 is CU 19,000,000 resulting to a CU 1,300,000 revaluation surplus.
 
No change in the remaining useful life of the building as of April 30, 2025 (240 months less 63 months = 177 months)
 
The new depreciation should be CU 107,344.63 (CU 19M/remaining useful life of 177 months) but D365 FO is weirdly and wrongly calculating it as follows:
 
(Original Cost + Revaluation Surplus) /TOTAL useful life= (CU 24M+ CU1.30M)/240 months= 105,416.67
 
As I understand, the new depreciation amount should equal to the new value distributed to the remaining useful life.
 
Are we doing anything wrong in the revaluation of the asset that causes the wrong depreciation expense calculation?
 
Best regards,
 
Eugene
 
 
Categories:
I have the same question (0)
  • Verified answer
    André Arnaud de Calavon Profile Picture
    299,782 Super User 2025 Season 2 on at
    Wrong Depreciation Amount after Revaluation
    Hi Eugene,
     
    Can you tell us what exact depreciation method is used for this asset? There is a difference in calculation between Straight line service life and Straight line life remaining. The first one takes the original amounts (including adjustments) and divides it by the total number of periods. The second mentioned takes the net book value and divides it by the remaining number of periods. The outcome is then different.
  • EugeneJohnCRR Profile Picture
    37 on at
    Wrong Depreciation Amount after Revaluation
    Hi Andre,
     
    I checked the asset and the depreciation method is Straight line service life. I am not aware who set this up. I only noticed now.
     
    Based on your explanation, I am wondering why there is such a depreciation method if it will not calculate the correct depreciation amount after impairment and/or revaluation.
     
    I tried changing the depreciation method, but it does not allow me to do so. A suggestion on how to change depreciation method would be highly appreciated.
     
    In all cases, thank you very much for your answer. Now it all makes sense why such is the case.
  • André Arnaud de Calavon Profile Picture
    299,782 Super User 2025 Season 2 on at
    Wrong Depreciation Amount after Revaluation
    Hi Eugen,
     
    I thought it is not possible to change the depreciation method for a current asset book. You can try to close this one and setup a new book for the current asset. 
  • EugeneJohnCRR Profile Picture
    37 on at
    Wrong Depreciation Amount after Revaluation
    Hi Andre,
     
    That's unfortunate... They have to discontinue the straight line service life as it tends to not follow the correct calculation depreciation.
     
    Is it possible to change the book of the same asset? This really makes my head spin.
     
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 765 Super User 2025 Season 2

#2
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 743

#3
Sumit Singh Profile Picture

Sumit Singh 551

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans