Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX (Archived)

Fixed Asset Depreciation Projection

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

What is the best way to forecast future monthly depreciation by asset "group" for budgeting purposes?  Is there an existing report with this type of format?

*This post is locked for comments

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Fixed Asset Depreciation Projection

    Hello Jule,

    I just checked my old documents but don't have exported this report project. The only thing that I have available are the documents that I used for this post. If you need it then please send me a short note to my private email.

    Best regards,

    Ludwig

  • JuleWergne Profile Picture
    JuleWergne 338 on at
    RE: Fixed Asset Depreciation Projection

    Hello Ludwig,

    I've got also the question if it is possible to make FA depreciation forecast for the next years. We use AX2012 R3, one FA value model and no depreciation books.

    I came across your blog https://dynamicsax-fico.com/2015/02/22/depreciation-forecast-report/

    Could you possibly explain a bit, what minor adjustments exactly you made to get the cumulated forecast values, and not separately for each fixed asset?

    Unfortunately I couldn't recognize that from the screenshot in the blog:

    2020_2D00_04_2D00_30-10_5F00_38_5F00_16_2D00_Depreciation-Forecast-Report-_5F00_-Dynamics-365FO_5F00_AX-Finance-_2600_-Controlling.png

    Thank you very much!

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Fixed Asset Depreciation Projection

    Hello dinashot,

    Do you need this for GP or AX?

    Best regards,

    Ludwig

  • dinashot Profile Picture
    dinashot 10 on at
    RE: Fixed Asset Depreciation Projection

    This report does not exist in GP2018.  How can I get projected depreciation/amortization for 2020?

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Fixed Asset Depreciation Projection

    Another solution is to use a FA journal with a depreciation proposal in the future date.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Fixed Asset Depreciation Projection

    Hello Jim,

    In addition, there is a country-specific report available that you might use for your purpose. I once described it here: dynamicsax-fico.com/.../depreciation-forecast-report

    Maybe this does also help.

    All the best,

    Ludwig

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Fixed Asset Depreciation Projection

    Thanks, Ludwig.  I am looking for a report that shows projected monthly depreciation expense of existing assets for future periods.  I would like it summarized to the asset group level.  We would use this report to create the future year budgets for existing assets.  It really is a projected depreciation journal for future months.  Again, thanks for your help and input!

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Fixed Asset Depreciation Projection

    Hi Jim,

    If you record Budget values on fixed assets then you can can make use of the Report "future value of fixed assets" available in the Report section in the FA module.

    Hope this helps,

    Ludwig

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,391 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans