ddb Function [AX 2012]
Updated: November 24, 2009
Applies To: Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012
Calculates the accelerated depreciation of an asset.
real ddb(
real price,
real scrap,
real life,
int period)
The book value for a specific period is equal to the purchase price minus the accumulated depreciation for previous periods:
-
Book value for Period 1 = Price
-
Book value for Period 2 = Book value for Period 1 - depreciation for Period 1
-
Book value for Period n = Book value for Period (n-1) - depreciation for Period (n-1)
There are three variations for the calculation of depreciation:
If Period > Life:
-
Depreciation = 0
If (Book value for Period n) - ((Book value for Period n) * 2/Life) < residual value:
-
Depreciation = (Book value for period n) - Residual value
In all other cases:
Depreciation = (Book value for period n) * 2 / Life
The syd and sln functions also calculate the depreciation of an asset. syd and ddb permit higher depreciation for the earlier years while sln calculates a linear depreciation.
-
ddb(12000,2000,10,1); //Returns the value 2400.
-
ddb(12000,2000,10,3); //Returns the value 1536.
Announcements: To see known issues and recent fixes, use Issue search in Microsoft Dynamics Lifecycle Services (LCS).