Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

Incorrect last month depreciation

Posted on by Microsoft Employee
I have an issue at a client where the monthly depreciation for the last financial month (June 2010) is less than the previous month (May 2010) where it is supposed to be the same. I have made sure that my Fixed asset calender and the great plains financial calender is exactly the same and i have rebuild it anyway. I backed out the depreciation If I run a depreciation projection for next month (July 2010 - first month of new financial year) the amount is correct again as the May 2010 figure. I was not able to find any articles on partnersource or google on this topic. Can any one please assist as we are trying to do a year end but cannot close until this has been fixed.

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Re: Re: Incorrect last month depreciation
    Thanks for your previous reply, after further investigation I found your explanation to be exactly what happened. My monthly depreciation now is wrong for 12 months being higher for 11 months and then lower the last month but my yearly depreciation is 100% correct. My only concern now is to find out why this happened? Thank you
  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Re: Incorrect last month depreciation
    The depreciation amount for this specific and about 200000 other assets (I spot checked a couple so I am assuming that all are the same) was the same for the entire financial year, each month the same amount except for period 12. I have reverted the depreciation and run it again but it still calculated a lesser amount than expected. And i am using straight line full month method for calculating depreciation. This issue does not occur on all the assets, only on about half of them. They appear to be random. I have assets that calculates the same amount for all 12 periods while using the same calculation methods as the asset that i am having issues with.
  • Sunbeam De Jesus Profile Picture
    Sunbeam De Jesus 3,930 on at
    Re: Incorrect last month depreciation

    Hi,

    So your problem now is June 2010 depreciation. Usually and depending on depreciation method you are, in GP FA the last month of the FY depreciation is a different amount from rest of the month. FA will sum all rounding off difference for the past 11 months and inlcude this amount in your 12th month depreciation. 

    But anyway, you can revert back to May 2010 by performing depreciation again on this month, 011 period, year 2010. This process will back out your June Depreciation since this will place all your assets depreciated to date end of May. The process will create an entry in your GL as well if you perform GL interface.

    As usual better if you can back up your database first before performing anything.

    FYI, if you really wanted to use straightline better use depreciation method Amortization, Periodic. GP FA strightline is calculated daily. You cannot expect an equal depreciation amount all throughout. 

    hope this....

      

     

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!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans