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)

difference in depreciation value through Straight line service life

(0) ShareShare
ReportReport
Posted on by 281

Hi Folks,

Hope you are doing Good.

I have created fixed asset with following details:

-Depreciation method: Straight line service life

-Life cycle = 3.00

-Acquisition date: 6/13/2015

-Expected scrap value = 5000.00

-Acquisition price = 30000.00 (Acquisition transaction has already posted)

Now i have entered the Placed in service and Depreciation run date as start of Acquisition's month i.e. 6/1/2015 
Now i have created the deprecation transaction for three years through Depreciation proposal. 

So the depreciation should be calculated for every month as:

(Acquisition price - Expected scrap value)/Total number of periods

So in my case (30000-5000)/36 = 694.00

But the first and last moth's depreciation amount is not as i expect, below is transactions detail:

Date Transaction type Account Value model Description Debit Credit Offset account type
6/30/2015 Depreciation 3666 Comp_Equip 685.00 Ledger
7/31/2015 Depreciation 3666 Comp_Equip 694.00 Ledger
5/31/2018 Depreciation 3666 Comp_Equip 719.00 Ledger


Transactions that have date
6/30/2016 and 5/31/2018, not calculating depreciation according to standard formula, anyone have any idea about it ?

-Rahat Ali

*This post is locked for comments

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

    Hi, can you check whether the depreciation convention"full month" is setup in your value model? Ludwig

  • Rahat Ali Profile Picture
    281 on at

    Hi Ludwig,

    Thanks for your reply.

    Now I have selected the Depreciation convention = Full month, now first month is correct, it is depreciation with full amount but still in last month it depreciation with amount 16.00. Line is below:

    Date            Transaction type Account Value model Description Debit Credit

    6/30/2018   Depreciation  3666 Comp_Equip                        16.00

    In my first post the date of last transaction was 5/31/2018, now depreciation take one extra month with amount 16.00

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hi Rahat,

    I think the 16$ is a mathematical / rounding issue.

    With an acquisition cost of 30000 and a scrap value of 5000 you depreciate 25000 over 36 month.

    36000 : 36 month = 694,4444444

    If you multiply the 0,44 Cents for 36 months you end up with 15,84 or - rounded 16.

    Can you check in the fixed asset value model what has been setup as round off depreciation?

    Can you also check what has been setup in the fixed asset parameters as minimum depreciation?

    Please also check the rounding rules setup in GL for your currencies.

    Please try to test what difference a modification of those parameters makes to your depreciation amounts.

    Best regards,

    Ludwig

  • Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hello Rahat,

    Just wondering whether you have been able to fix your issue or whether some additional Information/help is required.

    Best regards,

    Ludwig

  • Rahat Ali Profile Picture
    281 on at

    Hi Ludwig,

    Sorry for late response i was busy in some other tasks.

    Now i set round off depreciation = 0.00, previously it was set as 1.00.

     Minimum depreciation is set as = 10.00.

    Now system is calculating per month depreciation = 694.44, and on last month = 0.16,

    most probably it is calculating last month depreciation as: 0.0044444 * 36 = 0.1599984 = 0.16.

    I am trying to give different values on these parameter to get my result.

    If you have any other idea then please let me know. 

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
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans