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

I have the same question (0)

All responses (5)

Answers (2)

Verified answer

Mansi Soni 8,911 Super User 2025 Season 2 on at

Like (3)

Report

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/

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 20,966 Super User 2025 Season 2 on at

Like (2)

Report

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

Was this reply helpful? Yes No
Verified answer

KasparsSemjonovs 4,782 Super User 2025 Season 2 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Jainam M. Kothari 15,639 Super User 2025 Season 2 on at

Like (2)

Report

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

Was this reply helpful? Yes No
CU20030844-0 44 on at

Like (0)

Report

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)

Was this reply helpful? Yes No