How To Set Up Import FA Entries

The Import FA Entries functionality in Spider allows users to import FA Ledger Entries from external sources into the system. This feature is particularly useful for companies that need to import data from multiple sources or migrate data from legacy systems to Business Central.

Note

The Import FA Entries functionality in Spider only posts FA Ledger Entries and not general ledger entries. If you need to post both FA Ledger Entries and general ledger entries, use the Import G/L Entries and select Fixed Asset as the Account Type.

The Import FA Entries feature in Spider is flexible and can be configured to meet specific requirements. Users can define the mapping between the source data and the fields in Business Central. The Import FA Entries feature also supports various file formats, including Excel and delimited files, making it easy to import data from different sources.

Tip

Find the workflows for Importing Files.

It is possible to use the Communication Methods available within Spider, such as S/Ftp, Ftp, Azure File Storage, Azure Blob Storage and SharePoint Online.

Tip

If the Eagle app is installed it is possible to import and process the files across multiple companies.

Step 1: Create Integration

Important

The Depreciation Books must be set to G/L Integration = No on the Depreciation Book page for all the posting types that applies, to be able to post the imported file using the Import FA Entries feature in Spider.

  1. Choose the search icon (ALT+Q), enter Integrations, and then choose the related link.
  2. On the General FastTab:
    1. Select New.
    2. Enter a Code.
    3. Select Import FA Entries in the Integration Type field.
  3. On the Communication FastTab:
    1. Select an existing Communication Method.
    2. Enable the Include in Import field, which allows the files to be imported into the Integration Queue without having to manually select them.

Step 2: Add Additional Settings

  1. Select the Additional Settings action.
  2. Specify the settings that apply to the file to be imported on the General and Columns FastTabs. See details below.

First, the settings that need to be made on the General and Columns FastTab are described, then the settings that need to be specified for the file settings are described.

The General FastTab

The File Settings Code has been created with default settings using the same name for the Code as the integration code. The File Settings is used to define the settings for the file to be imported. The settings include the data type, date format, encoding, and other file-specific settings.

Most important fields on the General FastTab:

  1. Select a Posting Nos if the file to be imported (the source data) doesn't contain a column with the document number. This will be used to generate a unique document number for all imported entries (for each file). It is recommended to use a unique posting number series to differentiate between different sources.
  2. Select a Source Code. This is the code that will be used to identify the source of the imported data. It is recommended to use a unique code to differentiate between different sources. This code can be used when analyzing the imported data or when filtering FA ledger entries.
  3. Select a Default Posting Date if the file to be imported (the source data) doesn't contain a column with the posting date. This date will be used as the posting date for all imported entries. It is recommended to use Today if the file doesn't contain a date column.

The following fields are optional:

  1. The Check Column Headers field specifies whether the file's column headers should be checked against what has been set for this integration. This setting is only active if the file setting has Column Headers enabled.
  2. The Language field is used for specifying the language that is used in the file for fields of the Option type. This setting will also affect the language used in any error messages displayed when processing a file.

The Columns FastTab

You need to specify the mapping between the columns in the source data and the fields in Business Central. This mapping is used to ensure that the general ledger entries are created (posted) correctly.

The imported transactions are posted to the FA Ledger Entries table in Business Central directly and not via a journal so it is not necessary to specify a journal template or journal batch.

Tip

You can find all the fields available for mapping, along with brief explanations in the Integration Queue Fixed Assets Journal.

The Type field specifies the type of data that is expected.

Option When to use Example
Field Select Field if the data is a column in the file. The file contains a column with the G/L account.
Dimension Select Dimension if the data is a dimension code. The file contains a column with the department code.
Default Value Select Default Value if the field should be populated with a fixed value. The file does not contain a column with this data, but is required.

An example file to map:

The file contains the following columns and should be imported into Business Central:

  • Column A: Date
  • Column B: Verification number
  • Column C: Fixed Asset number
  • Column D: Posting Type
  • Column E: Amount
  • Column F: Description

How to map:

Type Column No. Column Header Field Name Dimension Code Default Value
Field 1 Date Posting Date
Field 2 Verification number Document No.
Default Value Account Type Fixed Asset
Field 3 Fixed Asset number Account No.
Field 4 Posting Type FA Posting Type
Field 5 Amount Amount
Field 6 Description Description
Default Value Depreciation Book Code COMPANY
Default Value No. of Depreciation Days 30
Note

The Account Type is used to specify the type of account and the most common are G/L Account, Customer, Vendor, Bank, Fixed Asset, and Resource.

Note

In the above example it is the Depreciation Book Code COMPANY that must be set to G/L Integration = No on the Depreciation Book page for all the posting types that should be imported and posted.

Tip

Select the Import Template action to upload the file that you want to manage in this integration to facilitate the settings on the Columns FastTab. The file needs to contain column headers so that it is possible to link the columns to the correct fields. You may need to specify the file settings that applies to the file to be imported.

Step 3: Specify File Settings

  1. Select the File Settings action.
  2. Specify the settings that apply to the file to be imported on the General and Settings FastTabs. See details below.

Add a Description on the General FastTab if you want to describe the file settings. The File Settings is used to define the settings for the file to be imported. The settings include the data type, date format, encoding, and other file-specific settings.

The Settings FastTab

  1. Select the Data Type that applies to the file to be imported.
    1. The most common data types are Excel and Delimited.
    2. For Excel files, no additional settings are required.
    3. For Delimited files, specify the delimiter used in the file.
      1. The other fields are optional to change and can be used to specify the date format, encoding, decimal format and if the file contains column headers.
Tip

Select the Export Template action to download a sample file according to the settings that have been made.

See Also

How To Set Up File Imports - Overview
How To Set Up Communication Methods
Workflows - Spider