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 :
Microsoft Dynamics GP (Archived)

period fixed asset depreciation rates are incorrect

(0) ShareShare
ReportReport
Posted on by 495

My client recently imported their fixed asset list. 

When they ran the monthly depreciation, about 30 assets (roughly 10% of the total) either had zero depreciation or a very small amount.  Most of the assets are very similar with straight line depreciation and 5 year life.  The incorrect rates do not seem to be related to class or account group. 

The basic problem appears to be the periodic rate is wrong.  The annual depreciation rate is correct but the period rate is closer to the daily rate and the daily rate is just pennies.   If I change the life to 4 years and click recalculate, the annual, periodic and dialy appear correct.  If I change back to 5 years, the annual rate is corrrect but the other revert back to the wrong rates.  If I try changing to 6 years liffe and recalculte, the annual rate again is correct but the periodic and daily rates are wrong. 

Strangely enough, checking the same assets in the test company, the rates are correct and the settings seem the same.

 

Any suggestions a\on what to check?

 

Thanks,

Claude

 

 

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Sunbeam De Jesus Profile Picture
    on at
    Re: period fixed asset depreciation rates are incorrect

    FA class or account group has nothing to do with depreciation amounts.

    There are case sensitive fields in calculating depreciation i.e. depreciated to date, dep method, ave convention etc. plus your assets are imported, this may affect ytd and ltd dep during recalculation.

    Pick one from your 30 assets and encode manually using FA gen and FA book GP windows. Off course use other FA ID as it needs to be unique. Try to perform depreciation and observe how the system calculates depr. I am certain that depr amount errors has nohting to do with using 5 or 6 years life. The system should calculate properly.

    Don't  focus on converting daily with periodic and yearly as number of days in a month\period may differ.

    Try to run depreciation for full year, you will see that the rouding difference will be distributed evenly on the last 2 or 3 periods, being the full year depreciation amount correct if you calculate manually.

    If you want to use real straight line, try to use amortization method.

    I hope this helps

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…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans