Fixed Assets can now be imported in bulk when setting up a new company in Business Central.

Company Setup Toolkit adds in new functionality to import Fixed Asset data from a file into your company.

  1. Open Fixed Asset Setup.
  2. Select Import Fixed Assets action on the Actions bar.
  3. Fill out the necessary fields on the request page.
  4. Run the report and wait for the import to complete.

Format of your data file

The data file is a tab delimited text file. It includes column headers which are listed below:

3FA Class Code
4FA Subclass Code
5FA Location Code
6Vendor No
7Warranty Date
8Resp Employee
9Serial No.
10FA Posting Group
11Depreciation Book 1
12Depreciation Method 1
13Declining Balance % 1
14Depreciation Years 1
15Straight-Line % 1
16Depreciation Start Date 1
17Aquisition Cost 1
18Accumulated Depreciation as at Prior Year End 1
19Accumulated Depreciation Current Year
20Acquisition Date 1
21Depreciation Book 2
22Depreciation Method 2
23Declining Balance % 2
24Depreciation Years 2
25Straight-Line % 2
26Depreciation Start Date 2
27Aquisition Cost 2
28Accumulated Depreciation as at Prior Year End 2
29Accumulated Depreciation 2
30Acquisition Date 2
31Depreciation Book 3
32Depreciation Method 3
33Declining Balance % 3
34Depreciation Years 3
35Straight-Line % 3
36Depreciation Start Date 3
37Aquisition Cost 3
38Accumulated Depreciation as at Prior Year End 3
39Accumulated Depreciation 3
40Acquisition Date 3
41Dimension Value 1
42Dimension Value 2
43Dimension Value 3
44Dimension Value 4
45Dimension Value 5
46Dimension Value 6
47Dimension Value 7
48Dimension Value 8