Import Fixed Asset with error

(8) Share

Report

Posted on by LL-31070241-0

Dear All,

I am sorry that I am new to Business Central. Hope someone could help me solve the problem.

As the company has quite a lot of fixed assets purchased before, so I would like to import the fixed assets by Excel table, with using Configuration Package. Originally, I use the object 5600 - Fixed Asset - to create the FA card. Then I am planning to use the object 5601 - FA Ledger Entry - for entering the /Acquisition cost/ & /Depreciation/ as the fixed assets' opening balance amount. However, error occurred and showed /TableData 5601 FA Ledger Entry Insert: Base Application/. It also reflected that I do not have the authority to take any action with the field /Dimension Set ID/. But of course I have not entered any data in /Dimension Set ID/. Will anyone know how to deal with it?

Or may I know the correct step for importing the post purchased fixed assets? I tried to follow below video with using 5621 Fixed Asset Journal, but it also failed. It will say the fixed assets could not be found and so that I have to create the FA card first.
https://www.google.com/search?q=dynamics+365+assets+import+cards&sca_esv=2f800a701f0b426f&ei=47kUZq6MBYax2roPhv68oAo&ved=0ahUKEwjuiaWLnLSFAxWGmFYBHQY_D6QQ4dUDCBA&uact=5&oq=dynamics+365+assets+import+cards&gs_lp=Egxnd3Mtd2l6LXNlcnAiIGR5bmFtaWNzIDM2NSBhc3NldHMgaW1wb3J0IGNhcmRzMgUQIRigATIFECEYoAFI6yNQrQdYlBBwAXgAkAEAmAFqoAHNA6oBAzUuMbgBA8gBAPgBAZgCB6AC3QPCAg4QABiABBiKBRiGAxiwA8ICBRAhGJ8FwgIEECEYFZgDAIgGAZAGAZIHAzYuMaAH1Bg&sclient=gws-wiz-serp#fpstate=ive&vld=cid:350e690c,vid:YuGFebSYgzw,st:0

Many thanks.

I have the same question (0)

All responses (3)

Answers (3)

Verified answer

techreviews.digital 376 on at

Like (3)

Report
Copy link

Link copied!

Hi,

Hope all is good.

For Fixed Assets Import, the related Fixed Asset Master data information must already be updated in Business Central. Please find below the information on the Master Data tables for Fixed Assets.

Secondly, please make sure that the related Depreciation Book is assigned on the Fixed Assets Card page.

Third: Please make sure that you have configured the FA Posting Type Setup and FA Journal Setup is configured correctly in the Depreciation Books.

Lastly: For entering the /Acquisition cost/ & /Depreciation/ as the fixed assets' opening balance amount, please use Fixed Asset G/L Journal.

I hope this resolves all your concerns related to updating the Fixed Assets opening balances.

Best Regards,

Sheikh Muhammad Jawad

Was this reply helpful? Yes No
Verified answer

YUN ZHU 98,012 Super User 2026 Season 1 on at

Like (4)

Report
Copy link

Link copied!

Hi, It is recommended that you operate it in a test company or environment first, such as the fixed assets procurement process.

More details: https://www.elian-solutions.com/how-to-create-and-purchase-fixed-assets-in-business-central/

Then, import the tables you'll need along the way.
This is how everyone learns in the beginning.

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No
Verified answer

Gerardo Rentería Ga... 25,545 Most Valuable Professional on at

Like (4)

Report
Copy link

Link copied!

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

Dynamics 365 Business Central – How I post opening balances for reducing balance Fixed Assets

A Strategy for Opening Balances in Business Central - Dynamics 365 Business Central

Upload Opening Balance (Inventory & FA) with RapidStart in D365 BC | Session - 50 | In Hindi

Best Regards
Gerardo

Was this reply helpful? Yes No