Skip to main content

Notifications

Small and medium business | Business Central, N...
Suggested answer

How to revise the Straight Line % of a Fixed Asset

(0) ShareShare
ReportReport
Posted on by 10

Hi All,

Can anyone suggest how to revise the Fixed Asset depreciation Straight Line % without modifying the existing %?

For example:

My asset has a straight line % of 5 till 1st June 2021 and it got revised to 4.7 and the user needs both the records.

Thanks in advance,

Srinivas Maddula.

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How to revise the Straight Line % of a Fixed Asset

    Srinivas,

    The Fixed Asset Depreciation Method - Straight Line is outlined below.

    Straight-Line Depreciation

    When you use the straight-line method, you must specify one of the following options in the fixed asset depreciation book:

    • The depreciation period (years or months) or a depreciation ending date
    • A fixed yearly percentage
    • A fixed yearly amount
    • Depreciation period

    Depreciation Period

    If you enter the depreciation period (the number of depreciation years, the number of depreciation months, or the depreciation ending date), the following formula calculates the depreciation amount:

    Depreciation Amount = ((Book value - Salvage Value) x Number of Depreciation Days) / Remaining Depreciation Days

    Remaining depreciation days are calculated as the number of depreciation days minus the number of days between the depreciation starting date and the last fixed asset entry date.

    Book value may be reduced by posted appreciation, write-down, custom 1 or custom 2 amounts, depending on whether the Include in Depr. Calculation field is deactivated and whether the Part of Book Value field is activated on the FA Posting Type Setup page. This calculation ensures that the fixed asset is fully depreciated at the depreciation ending date.

    Fixed Yearly Percentage

    If you enter a fixed yearly percentage, application uses the following formula to calculate the depreciation amount:

    Depreciation Amount = (Straight-Line % x Depreciable Basis x Number of Depr. Days) / (100 x 360)

    Fixed Yearly Amount

    If you enter a fixed yearly amount, application uses this formula to calculate the depreciation amount:

    Depreciation Amount = (Fixed Depreciation Amount x Number of Depreciation Days) / 360

    Example - Straight-Line Depreciation

    A fixed asset has an acquisition cost of LCY 100,000. The estimated life is eight years. The Calculate Depreciation batch job is run biannually.

    For this example, the fixed asset ledger entry looks like this:

    EXAMPLE - STRAIGHT-LINE DEPRECIATION
    Date FA Posting Type Days Amount Book Value
    01/01/20 Acquisition Cost (Depreciation starting date) 100,000.00 100,000.00
    06/30/20 Depreciation 180 -6,250.00 93,750.00
    12/31/20 Depreciation 180 -6,250.00 87,500.00
    06/30/21 Depreciation 180 -6,250.00 81,250.00
    12/31/21 Depreciation 180 -6,250.00 75,000.00
    06/30/27 Depreciation 180 -6,250.00 6,250.00
    12/31/27 Depreciation 180 -6,250.00 0

    Hope this helps.

    Thanks,

    Steve

  • Suggested answer
    RE: How to revise the Straight Line % of a Fixed Asset

    Hello,

    If I have well undestood the depreciation straight line percentage have to be changed and the fixed asset depreciation continues with the new percent value but is needed to keep track of the previous depreciation percentage.

    The only way I see to achieve this is reclassifing the residual value of the fixed asset in a new Fixed Asset and set in the related Depreciation Book the updated percentage and the updated depreciation starting date.

    I hope this helps.

    Alessandra Pandini

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

News and Announcements

Announcing Category Subscriptions!

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

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,359 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,370 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans