Skip to main content

Fixed Assets

Business Value​

When you need to create a large number of fixed assets you need a fast way to do it. This feature allows you to import new or update existing fixed assets using a single Excel worksheet. The import creates/updates Fixed Assets, FA Depreciation Books, Main Asset/Component and also creates opening transactions.

Possible Scenarios​

  • You can use this feature to a Fixed Asset Register into a new Business Central company. Using this feature is much faster than using a configuration package because you don't need to change the format of the file and split it into different tables.
  • If your purchase process does not support you first creating a fixed asset before placing an order, you can use this feature to create the new fixed assets and create the Fixed Asset Journals for the acquisition costs.

Feature Details​

The Fixed Asset import can be accessed from the Fixed Asset list. Fixed Asset Import

Settings​

Update Existing​

ValueDescription
YesUpdate existing records and add new records.
NoOnly add new records.

Balances Journal Type​

ValueDescription
FA Journal (Default)Import the opening balances to a Fixed Asset Journal, which is not integrated to the General Ledger. This us usually used when you are importing a Fixed Asset Register into a new company
General JournalImport the opening balances to a Fixed Asset G/L Journal.

Common Settings​

This template also includes common settings available on other templates.

Example 1: Importing a Fixed Asset Register for a new Company​

In this example, we use Excel Importer to upload a fixed asset register containing the fixed assets and the cost and accumulated depreciation. The example uses the existing Fixed Asset numbers, which is a common scenario when you move an existing fixed asset register into Business Central.

Excel file​

Fixed Asset Excel

Excel Mapping Template​

Fixed Asset Mapping Template

note

When you import this file, Business Central will display an error if the Fixed Asset number series is configured for automatic numbering only.

tip

If you want Business Central to assign numbers automatically, do not map the No. field. The app will create a new Fixed Asset for every row in the file and automatically assign the following number.

Imported Data​

We configured this template to import the Fixed Assets and create a journal for the opening balances.

Fixed Assets​

Imported Fixed Assets

Fixed Asset Journal​

Fixed Asset Journal

Example 2: A more complex example with mapping​

note

This example is intended for consultants or advanced users frequently migrating data from legacy systems.

In this example, we mapped the asset register from a legacy system to Business Central. The columns in yellow got added as we had to derive some values from other columns.

Excel file​

Fixed Asset Excel

Excel Mapping Template​

Please note the following regarding the image below:

  1. We have specified a row filter to exclude some rows. We have to do this because the client generated the source file from a report out of the legacy system, and the report includes totals per asset class. It's easier to filter out the rows we do not want instead of reformatting the file.
  2. We have created a mapping template to map column E to the depreciation method.
  3. The opening entries will be posted on the 30th of June, 2023, so we have specified this in the template.
  4. The FA Subclass Code is a vital field here because it is used to default the FA Posting Group for the FA Depreciation Books.
  5. We have used the Only if Values option, so the validation code behind the field is only triggered when the column has a value.

Excel Mapping Template

Step-by-Step Guide​

This guide presents the steps required to import Fixed asset records into Business Central and their associated acquisition cost and accumulated depreciation amounts using a single import template in Excel Importer.

See Also​

tip