Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 Community / Forums / Finance forum / Import fixed asset wit...
Finance forum
Answered

Import fixed asset with accumulated depreciation

Posted on by 1,134

Hello, 

I am seeking some help on importing fixed assets. I have a requirement of importing assets with accumulated depreciation (in FA sub ledger). What should be my approach? For an example, I am an asset A acquired on Jan 1, 2017 with a life of  3 years. The acquisition value was $3600. The net book value as of June 30 2019 is $600. I have an accumulated depreciation of $2,400. How should I bring $2,400 (as depreciation) and $600 (as net book) so that I can continue depreciating it at $100 per month from Jul 31 to Dec 31 2019.

  • Suggested answer
    BillurSamdancioglu Profile Picture
    BillurSamdancioglu 13,600 Super User 2024 Season 2 on at
    RE: Import fixed asset with accumulated depreciation

    Yes, You can either do that way with  to update asset book or there is a feature for assets.  You may activate that functionality. And mark assets as imported assets.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Import fixed asset with accumulated depreciation

    Andre

    When you brought the acquisition date/placed in service date and remaining periods, did you do this after you had posted both the Acq and Depr journals?

  • Verified answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 290,252 Super User 2024 Season 2 on at
    RE: Import fixed asset with accumulated depreciation

    Hi Kumar,

    With the replies from Saurav and Ludwig, you should be able to complete your task. Usually, I did import the assets with the value models, then did the acquisition and depreciation journals as stated above. Using the Asset master data sheet, I did another import to update the correct values for the remaining depreciation periods, acquisition date and last depreciation date.

    When all was imported, I did create an asset journal to check if a new depreciation run would give the correct values.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Import fixed asset with accumulated depreciation

    Hello Kumar,

    When you make your import / transfer postings then - depending on how you make them - the remaining deprecation period number that you can find in the fixed asset books might change. Before you start using D365FO 'live' you can open the fixed asset books entity - for example in Excel - and double check that the periods are still ok. If they are not, you can directly update them via the Excel addin.

    Best regards,

    Ludwig

  • Suggested answer
    SouravDam Profile Picture
    SouravDam 11,721 on at
    RE: Import fixed asset with accumulated depreciation

    Hi Kumar,

    Acquisition value as on Jan 1, 2017 is $3600. You have a net book value $600 as on June 30, 2019.

    The Accumulated depreciation value you mentioned as $2400.

    This accumulated depreciation of $2400 is the total depreciation value for last 2 years upto Dec 31, 2018 considering that every month it was depreciated for $100. Question is;

    --- Are you considering this depreciation value also as on date June 30, 2019 or considering it upto Dec 31, 2018 as ideally it calculates ?

    --- If you are considering this depreciation value as a balance as on June 30, 2019, then where the depreciation amount of $600 you have recorded starting from Jan 1 to June 30, 2019 which ultimately leaves a net book balance of $600 as on June 30, 2019 ?

    Kindly help me to understand this to get a better clarity.

    Best regards,
    Sourav Dam

    Please take time to click 'Yes' against the answers that help you guide in right direction to help other community members.

  • Kumar_Sat Profile Picture
    Kumar_Sat 1,134 on at
    RE: Import fixed asset with accumulated depreciation

    I am sorry but this does not answer my question. The moot question is not the data import but how to make sure the remaining life will remain the same and the depreciation per month should remain constant during the remaining period.

  • Suggested answer
    SouravDam Profile Picture
    SouravDam 11,721 on at
    RE: Import fixed asset with accumulated depreciation

    Hi Kumar,

    You have to create 2 separate fixed assets journal. One journal has to post with acquisition value and the other one has to post with accumulated depreciation value. Once both journals are posted; system will show you the net book value of that asset.

    Else; if you have large number of fixed assets; you have to do the following.

    --- First; generate the template from data management. You can use the fixed asset journal entity to export the template.

    --- Upload the acquisition value of fixed assets by using this entity. Post the fixed asset acquisition journal.

    --- Upload the accumulated depreciation value of fixed assets by using this entity. Post the fixed asset accumulated depreciation journal.

    Once both journals are posted; system will show you the net book value of that asset.

    Best regards,
    Sourav Dam

    Please take time to click 'Yes' against the answers that help you guide in right direction to help other community members.

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 9th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,252 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,089 Super User 2024 Season 2

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans