Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Depreciation Calculation
Finance | Project Operations, Human Resources, ...
Answered

Depreciation Calculation

(0) ShareShare
ReportReport
Posted on by D365problems 105

Hello All, 

I've searched to see if anyone else had this issue but I was not able to locate a similar issue.  

Recently I began looking into fixed asset items that arose from when AX was implemented.  It's a implementation problem that needs reclass.  

However, one issue I noticed is that on new assets, depreciation is supposed to be straight line.  But with each month, it is subtracting depreciation from the prior month and then calculating depreciation straight line again.  

pastedimage1592585737623v1.png

pastedimage1592585761340v2.png

pastedimage1592585787127v3.png

I'm not sure if the set up is incorrect in the depreciation book or the depreciation profile or the asset itself.  

Any ideas would be helpful. 

Thank you 

Christine 

  • Verified answer
    D365problems Profile Picture
    D365problems 105 on at
    RE: Depreciation Calculation

    Hi Ludwig,

    This matter is finally resolved!!!  

    The answer to this irritating item is the setup.  

    Based on the way AX was set up, we had to update the Value Models.

    Under the Value Models, SL, there is a box that needed to be selected.

    "Create depreciation adjustments with basis adjustments:"

    Once that box was checked, the depreciation was calculated correctly.  We tested in our test environment database.  Luckily IT was involved and they completed a mass update behind the scenes.  

    Thank you for all your assistance!

    Christine

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Depreciation Calculation

    Good morning Christine,

    Just wanted to follow up on this one and ask if you need any other help/information from the community or whether you have been able to get this issue resolved in the meantime?

    Best regards,

    Ludwig

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 294,459 Super User 2025 Season 1 on at
    RE: Depreciation Calculation

    Hi Christine,

    I have seen some other challenges with Straight line which would work more smooth with Straight line life remaining. The base of the calculation is different.

    Straight line takes the original number of periods and acquisition amount where the life remaining is taking the current remaining number of periods and the current book value.

  • D365problems Profile Picture
    D365problems 105 on at
    RE: Depreciation Calculation

    Hi Ludwig,

    As it turns out, it's the setup.  Depreciation Profile is Straight Line service life.  AX automatically, takes the depreciation on the remaining value of the asset rather than the original value of the asset.  

    If I change the Depreciation Profile to Straight Line life remaining, it will be the correct depreciation calculation.  I am going to go into the test environment to see what correcting the profile will do.  

    Wish me luck!

    Thanks for all your help!!!

    Christine

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Depreciation Calculation

    Hello Christine,

    Makes sense to me.  

    Would be great if you could keep us updated about your findings.

    Many thanks and best regards,

    Ludwig

  • D365problems Profile Picture
    D365problems 105 on at
    RE: Depreciation Calculation

    Hi Ludwig,

    Thank you

    I will speak with someone who was here at the time of implementation.  

    It seems a logical problem.  Because most of the assets are from projects.  

    Christine

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Depreciation Calculation

    Hi Christine,

    Is it possible that an adjustment was made that links your fixed asset depreciation to a project?

    Some people like having their depreciation amounts posted on projects in the project management and accounting module and I wonder whether something alike has been created in your environment.

    It might explain the strange amounts and behavior that you see.

    Do you have somebody from dev to look deeper into this?

    Best regards,

    Ludwig

  • D365problems Profile Picture
    D365problems 105 on at
    RE: Depreciation Calculation

    Thank you Ludwig and Andre,

    I tracked down the column '@ISN1028' is supposed to be the project number.  I would think that would not have a effect on the depreciation calculation.  

    Regarding the depreciation calculation, it is happening to all assets in the system.  

    Thank you

    Christine

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Depreciation Calculation

    Hi Christine,

    As Andre mentioned, please check with your system admins whether some modifications have been made for calculating and posting depreciation.

    Is this the only fixed asset that has this problem or is this something that you see for each and every fixed asset in your system?

    Best regards,

    Ludwig

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 294,459 Super User 2025 Season 1 on at
    RE: Depreciation Calculation

    Hi Christine,

    The field with the label '@ISN' indicates it is not a standard environment. This could be either a customization, partner solution or ISV solution. Can you check this internally or with your partner?

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

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Jonas ”Jones” Melgaard – Community Spotlight

We are honored to recognize Jonas "Jones" Melgaard as our April 2025…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 294,459 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 233,066 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans