Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Depreciation Calculati...
Microsoft Dynamics GP (Archived)

Depreciation Calculations for Straight Line Orig Life

(0) ShareShare
ReportReport
Posted on by sandipdjadhav 18,265

Dear All,

I like to know how Dynamics GP calculating Depreciation; in my senario GP calculating wrong.

We have run depreciation for one month i.e. Jan 31,2011

Assets Place in Service Date : 11/14/2006

Cost : 12683.67

Orginal Life : 05 yrs.

My Yearly Depreciation shows in GP : 2113.96 which should be  (1268367/5=2536.734)

and Current Depreciation : 202.62 which should be  (211.3945)

Why Dynamics GP shows different depreciation amount?

Your earliest reply is highly appreciable.

Thanks
Sandip

 

*This post is locked for comments

  • sandipdjadhav Profile Picture
    sandipdjadhav 18,265 on at
    Re: Depreciation Calculations for Straight Line Orig Life

    Thanks much for your clarification that help me to understand why it calculate wrong.. !!!

    Appreciate your help.

    Thanks

    Sandip

  • Zhigang Lu Profile Picture
    Zhigang Lu 795 on at
    Re: Depreciation Calculations for Straight Line Orig Life

    Sandip,

    Yearly Depreciation 2113.96 is only for 2011, 5 year depreciation, 11/14/2011 is the last day for depreciation, 2011 is not the whole year for depreciation, so the Yearly Depreciation won't be $2536.734. The following is the calculation for 2011 Yearly Depreciation.

    Cost Basis                    $12,683.67   $211.39 Per Month

    LTD Depreciation (51 months) 10,781.11

    YTD Depreciation (1 month) $211.39

    2011(Cost Basis - LTD Depreciation + YTD Depreciation) $2,113.96

    For question  why Current Depreciation is 202.62 which should be  (211.3945), maybe the following menu is useful for you to find some reason.

    Financial>>Inquiry>>Fixed Asset>>Financial Detail

  • sandipdjadhav Profile Picture
    sandipdjadhav 18,265 on at
    Re: Depreciation Calculations for Straight Line Orig Life

    Experts,

    Any luck? Still I am having same issue. I imported all FA with books informaiton.

    Waiting for your reply.

    Thanks

    Sandip

  • sandipdjadhav Profile Picture
    sandipdjadhav 18,265 on at
    Re: Depreciation Calculations for Straight Line Orig Life

    Rubal,

    Appreciate your prompt reply; I used "None" Average convention. I don't know why I am getting wrong result.

    Thanks

    Sandip

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Depreciation Calculations for Straight Line Orig Life

    Hi Sandip,

    Which averaging convention you are using? I just tested with ‘None’ averaging convention and yearly rate is exactly equal to the expected value (1268367/5=2536.734)

    Rubal,

    http://www.dynamicsgphelp.com/

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 Suggested Answers

Best practices for providing successful forum answers ✍️

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