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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

Fixed Asset Depreciation Projection

(0) ShareShare
ReportReport
Posted on by

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

I have the same question (0)
  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    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

  • Community Member Profile Picture
    on at

    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
    Microsoft Employee on at

    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

  • Suggested answer
    Community Member Profile Picture
    on at

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

  • dinashot Profile Picture
    10 on at

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

  • Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hello dinashot,

    Do you need this for GP or AX?

    Best regards,

    Ludwig

  • JuleWergne Profile Picture
    12 on at

    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
    Microsoft Employee on at

    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

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…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Priya_K Profile Picture

Priya_K 4

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#3
Ali Zaidi Profile Picture

Ali Zaidi 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans