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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Importing Fixed Assets...
Small and medium business | Business Central, N...
Answered

Importing Fixed Assets Data

(0) ShareShare
ReportReport
Posted on by john.ellis 3,500

Hi:

What fields in an Excel spreadsheet do I use to import fixed assets master data and, afterward, YTD accumulated depreciation as of 12/31/2021?

Likewise, for importing the latter, do I import the acquisition cost and then the YTD accumulated depreciation into the FA Journal Line table and do so separately?

Thanks!

John

I have the same question (0)
  • Dallefeld Profile Picture
    Dallefeld 193 User Group Leader on at
    RE: Importing Fixed Assets Data

    What you need to understand is that the Fixed Asset Master record is separate from the Fixed Asset Depreciation Book record. This is two separate tables in the database and you probably cannot Edit in Excel for the FA Depreciation Books record. The fixed Asset, just needs a number and name but category, andsubcategory are also helpful during reporting. You'll need FA Posting Group, depreciation, method, staring date, and life for the FA Depreciation book for each asset.

    Make sure that you integration to the GL is turned off before you bring in your beginning balances. Then to bring in your acquisition costs into the FA Journal line table, balance to GL and post. Do the same for your accumulated depreciation. Keep in mind the FA posting type and that depreciation amounts are negative.

    Don't forget to turn on your GL integration for your Depreciation Book.

  • john.ellis Profile Picture
    john.ellis 3,500 on at
    RE: Importing Fixed Assets Data

    So, there are three tables to import using a Configuration Package -- Fixed Asset Master (5600), FA Depreciation Book (5612), and FA Journal Line (5621).  Correct?

    You said "Then to bring in your acquisition costs..."  Are you saying that there are multiple imports into these tables?

    How do I turn off the G/L integration?

  • Verified answer
    Dallefeld Profile Picture
    Dallefeld 193 User Group Leader on at
    RE: Importing Fixed Assets Data

    The FA Journal Line, I bring in acquisition cost in one load, balance and post

    Then do the FA Journal Line for accumulated depreciation, balance and post

    GL integration is on the Depreciation Card.

  • john.ellis Profile Picture
    john.ellis 3,500 on at
    RE: Importing Fixed Assets Data

    Thanks, Kim!

    So, really, the only two tables to import into are the Fixed Asset Master (5600) and FA Journal Line (5621).  Is that right?

    John

  • Dallefeld Profile Picture
    Dallefeld 193 User Group Leader on at
    RE: Importing Fixed Assets Data

    No you have to import the FA Depreciation Books (table=5612), Depreciation details are not part of the FA Master, they are in a separate table.

  • john.ellis Profile Picture
    john.ellis 3,500 on at
    RE: Importing Fixed Assets Data

    Thanks, Kim!

    John

  • Suggested answer
    Dallefeld Profile Picture
    Dallefeld 193 User Group Leader on at
    RE: Importing Fixed Assets Data

    There is the Depreciation Book record (Company, Financial, Tax) and then there's the FA Depreciation Book records (one for ech asset).

    The FA Depr Book has the depreciation method, life, starting and ending depreciation dates. It's table number 5612

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

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

#1
Rishabh Kanaskar Profile Picture

Rishabh Kanaskar 4,285

#2
Sumit Singh Profile Picture

Sumit Singh 2,725

#3
Nimsara Jayathilaka. Profile Picture

Nimsara Jayathilaka. 2,526

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans