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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Fixed Assets Depreciat...
Microsoft Dynamics GP (Archived)

Fixed Assets Depreciation Method - Straight line remaining life

(0) ShareShare
ReportReport
Posted on by Community Member

Hi,

we are having problem in understanding how Dynamics GP compute the depreciation value based on that method.

Cost value = 12,000

Place in service date = 01-06-2017 (dd/mm/yyyy)

Original life = 5

Remaining life = 5

Depreciation method = Straight line Remaining Life

Averaging Method = Full Period

GP computed monthly depreciation = 200.9075

 

how does it derived ???

based on the provided formula is not able to compute.

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    anyone could help on this ???

    thank you.

  • Community Member Profile Picture
    Community Member on at

    Hi,

    The formula for Straight-line Rem Life is

    (Cost - Salvage Value - (LTD Depreciation Amount - YTD Depreciation Amount)) ÷ Remaining Life in Days

    This calculation determines the daily depreciation rate, which must be multiplied by the number of days in the year.

    Full Period = Assets that are placed in service at any time during the period will begin depreciating on the first day of the period.

    The depreciation of $200 is calculated as follow

    Daily depreciation will become =12000/(360*5)

    Monthly depreciation is = (12000/(360*5))*30

    = 200

    Rubal,

    http://dynamicsgphelp.com/

  • Community Member Profile Picture
    Community Member on at

    Hi Rubal,

    but system computed the value is 200.9075 = 200.91 and not 200.

    that is what troubling me....

    do you have any idea?

  • Community Member Profile Picture
    Community Member on at

    Hi,

    It might have something to do with rounding. If you calculate daily depreciation (12000/ (360*5) and round it to 2 decimal places and then multiply it 30 the value $200.10. but still not 200.91

    Rubal,

    http://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

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…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans