Import of already existing fixed assets

(2) Share

Report

Posted on by CU20030844-0

Hi, I am transferring my company to Business Central from another system, and I am wondering how I am supposed to import the fixed assets that are already posted in the previous system and depreciated on etc.

I am obviously going to post a FA card, but how do I match it up with the acc. depr. and net value of the asset at current state?

Thanks

Categories:

Dynamics 365 Business Central migration

All responses (5)

Answers (2)

CU20030844-0 22 on at

Like (0)

Report

Import of already existing fixed assets

Thank you so much, this was exactly what I needed! The video @Jainam M. Kothari mentioned was the one I had already watched, but the video before that was the one explaining exactly this. (the disablement of G/L accounts)
Suggested answer

Jainam M. Kothari 6,567 on at

Like (2)

Report

Import of already existing fixed assets

May thsi can help : https://www.youtube.com/watch?v=YuGFebSYgzw
Verified answer

KasparsSemjonovs 4,192 Super User 2025 Season 1 on at

Like (1)

Report

Import of already existing fixed assets

There are 2 options, depending on how You will transfer GL balances.
1) Use FA Journals. For this on depreciation book You need to temporarily disable Integration with GL. at the time of Posting. Lines in journal can be created with the needed FA Posting date for Acquisition (original or migration date) and Depreciation (either for each month, or just the total depreciation until time of migration). This will not create any GL entries, so make sure that the same balance is afterwards posted in the GL accounts for Acquisition costs and accumulated depreciation for each FA Posting Group.

2) Use FA G/L Journals - Lines in journal can be created with the needed FA Posting date for Acquisition and Depreciation (either for each month, or just the total depreciation until time of migration). The Bal.Account No. can be set up manually (if You want to post everything through a in-transit account) or retrieve it by selecting all lines and pressing the button to generate Bal. Account lines based on the Setups. In this way double check the G/L balance postings so that the amounts on FA acquisition and accumulated Depreciation are not posted in double.
Suggested answer

Khushbu Rajvi. 14,839 Super User 2025 Season 1 on at

Like (2)

Report

Import of already existing fixed assets

Hope this helps as well: https://community.dynamics.com/forums/thread/details/?threadid=50b0a5c1-1dc4-48b1-88be-7eb552203f4d

https://learn.microsoft.com/en-us/dynamics365/business-central/fa-how-acquire

https://content.clicklearn.com/public/9f1e7376-221f-47e7-8157-7fb60fe568e9/Excel%20Importer.5129/Excel%20Importer.htm?b=Setup&r=Excel%20Importer%20-%20Importing%20Fixed%20Assets%20Information
Verified answer

Mansi Soni 1,746 on at

Like (2)

Report

Import of already existing fixed assets

Hello,

In Business Central, to import fixed assets from another system while maintaining their accumulated depreciation and net book value this might be helpful to you

https://learn.microsoft.com/en-us/training/modules/record-fixed-assets-opening-transactions/
https://learn.microsoft.com/en-us/training/paths/manage-advanced-fixed-assets-transactions/