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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

Fixed Assets Depreciation configuration and calculation

(6) ShareShare
ReportReport
Posted on by 46
We are working in a sandbox environment for migrationg 30 companies from Dynamics GP to Dynamics 365 BC. 
 
We have worked our way through most of the fixed asset migration issues, replicating the calculations from GP in BC. 
 
The specific scenario that we cannot successfully replicate is GP 7 year original life DB200 Switch to Straightline Half year convention.   
 
From what I have read and experienced, D365 does not allow DB2/SL with Half year convention.   
 
We came up with the work around that others have also used. 
 
Use DB1/SL half year Convention but assign the DB200 28.57% Declining Balance % instead of the DB150 21.42%.    This works for 3 and 5 year Assets but it does not work for 7 year assets.     We are looking for a way to implement the DB2/SL depreciation methood with Half year convention  without having to create period by period Manual depreciation for all of our 7 year assets.   
 
Is this a known issue? 
 
Is there a Known solution? 
 
Is microsoft working on a fix that would allow DB2/SL with half year convention?
I have the same question (0)
  • Suggested answer
    OussamaSabbouh Profile Picture
    12,808 Super User 2026 Season 1 on at
    Hello,
     
    Business Central simply does not support this type.
    It’s a known limitation, not a configuration issue, and there’s no Microsoft fix planned.
    Your workaround only works for 3- and 5-year assets because BC’s depreciation engine can’t reproduce the correct switch timing for 7-year DB200 assets.
     
    In practice, partners handle this by either:
     
    building a small custom depreciation method (most accurate), or
     
    migrating accumulated depreciation and continuing with SL only.
     
     
    Regards,
    Oussama Sabbouh
  • AS-20111939-0 Profile Picture
    46 on at
    Thank you so much for your prompt reply. 
    We are doing this migration in house and I just wanted to make sure we are not missing some known solution.   
     
    For a test I have created a Depreciation Table and assigned it to one of the fixed assets. I am still having a little trouble getting the period percentages to match the Dynamics GP calculations, but I am sure we can come up with work around.   If you have a quick recommendation I would like your thoughts.
     
    In the Depreciation Table will I have to enter the percentages for 49 period (Month as a period) or will the system handle it if I create 8 periods (period = year).  The accounting people tell me that the half year convention is the issue.   Thank You 
     
    Something like this?
     
     
     
     
     
     
     
       
     
         
      1 14.28 0  
      2 28.57 0  
      3 28.57 0  
      4 28.57 0  
      5 28.57 0  
      6 40.00 0  
      7 66.77 0  
       
         
  • Suggested answer
    YUN ZHU Profile Picture
    99,055 Super User 2026 Season 1 on at
    Hi, hope the following can give you some hints.
    Depreciation methods for fixed assets
     
    Thanks.
    ZHU
  • Suggested answer
    Jainam M. Kothari Profile Picture
    15,732 Super User 2026 Season 1 on at
    Hello,
     
    Business Central does not currently support combining DB2/SL depreciation method with Half-Year Convention, which is why your workaround using DB1/SL with adjusted percentages works for shorter asset lives but fails for 7-year assets.
     
    This is a design limitation, not a bug, and Microsoft has not announced plans to add this functionality.
     
    The recommended solution is to either create a user-defined depreciation method that replicates DB2/SL with Half-Year Convention or build a custom extension to automate the calculation, as manual adjustments for each period would be cumbersome for large migrations.
  • AS-20111939-0 Profile Picture
    46 on at
    Can someone confirm exactly what Microsoft left out from the Dynamics GP Depreciation calculations.
     
    Does Dynamics 365 handle these methods that were supported in GP:
     
    DB200 switch to SL Half year
    DB150 Switch to SL Half year 
    DB200 switch to SL Mid Quarter
    DB150 Switch to SL Mid Quater 
    Straight-Line
     
  • Gerardo Rentería García Profile Picture
    25,555 Most Valuable Professional on at

    Hi, good day
    I hope this can help you, and give you some hints.

    Depreciation methods for fixed assets - Business Central | Microsoft Learn

    You can always record an idea related to this topic.

    Categories

    Best Regards
    Gerardo

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,926 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,158 Super User 2026 Season 1

#3
Khushbu Rajvi. Profile Picture

Khushbu Rajvi. 533 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans