Fixed Assets Template

Use these templates to import Fixed Assets.

This is typically delivered as the configuration package B-FIXED ASSETS.

You usually import two sets of records:

• Fixed Asset records
• Fixed Asset Depreciation Book records

Before you start

You need:

• ​Excel Template Data Migration​
• ​Configuration Worksheet

Fixed Asset template (FA master)

Export it from Configuration Worksheet on the Fixed Asset line.

Step-by-step

1

Export the template

1. Open Configuration Worksheet.
2. Select the Fixed Asset line.
3. Select Excel → Export to Template.

2

Populate rows

1. Create one row per fixed asset.
2. Make sure FA Posting Group exists.

3

Import and apply

1. Select Excel → Import from Template.
2. Fix any errors in the preview.
3. Select Apply Data.

4

Verify

1. Open Fixed Assets.
2. Filter on imported No. values.
3. Check posting group and dimensions.

Field reference (template columns)

Field list

The template has the following fields:

Field ID / Name	Related Table	FieldType	Note
1 No.		Code 20 (Mandatory)	Unique fixed asset reference. If fixed assets are being imported from another system, keep the same reference.
2 Description		Text 100 (Mandatory)
5 FA Class Code	(5607) FA Class	Code 10	Any value entered here must already exist in its related table.
6 FA Subclass Code	(5608) FA Subclass	Code 10	Any value entered here must already exist in its related table.
10 FA Location Code	(5609) FA Location	Code 10	Any value entered here must already exist in its related table.
11 Vendor No.	(23) Vendor	Code 20	The vendor no. you purchased the asset from. Any value entered here must already exist in its related table.
15 Warranty Date		Date	The warranty expiration date of the fixed asset.
16 Responsible Employee	(5200) Employee	Code 20	Any value entered here must already exist in its related table.
17 Serial No.		Text 50
23 Maintenance Vendor No.	(23) Vendor	Code 20	The vendor who performs repairs and maintenance on the asset. Any value entered here must already exist in its related table.
24 Under Maintenance		Boolean
25 Next Service Date		Date
26 Inactive		Boolean
29 FA Posting Group	(5606) FA Posting Group	Code 10 (Mandatory)	Any value entered here must already exist in its related table.
999999901 ..999999912 Dimension Code	(349) Dimension Value	Code 20	The Excel template will specify the specific dimension code to use here. Only use this field if the dimension code relates to your fixed asset. Any value entered here must already exist in its related dimension code table. Note: Do not enter values in the Duty dimension column. This dimension is used internally by the system.

Fixed Asset Depreciation Book template

Each fixed asset record will need a fixed asset depreciation book record. The fixed asset depreciation book template is a pre-formatted spreadsheet with the most common fields you need to create fixed asset depreciation books within Bevica. You can access the template from the Configuration Worksheet page, Fixed Asset Depreciation Book line.

Import fixed assets first. Then import depreciation books.

Step-by-step

1

Export the template

1. Open Configuration Worksheet.
2. Select the Fixed Asset Depreciation Book line.
3. Select Excel → Export to Template.

2

Populate rows

1. Create one row per FA depreciation book record.
2. Make sure the FA No. exists.
3. Make sure Depreciation Book Code exists.

3

Import and apply

1. Select Excel → Import from Template.
2. Fix any errors in the preview.
3. Select Apply Data.

4

Verify

1. Open a fixed asset card.
2. Check depreciation book lines.

Field reference (template columns)

Field list

The template has the following fields:

Field ID / Name	Related Table / Name	FieldType(1)	Note
1 FA No.	(5600) Fixed Asset	Code 20(Mandatory)	Any value entered here must already exist in its related table.
2 Depreciation Book Code	(5611) Depreciation Book	Code 10(Mandatory)	Any value entered here must already exist in its related table.
13 FA Posting Group	(5606) FA Posting Group	Code 20(Mandatory)	Any value entered here must already exist in its related table.
3 Depreciation Method		Option(Mandatory)	• Straight-Line • Reducing-Balance • Double Declining-Balance • Sum of Digits • Annuity Method • User-Defined • Manual
4 Depreciation Start Date		Date(Mandatory)
6 No. of Depreciation Years		Decimal(Optional)	Either enter the no. of depreciation years or the depreciation ending date.
14 Depreciation Ending Date		Date(Optional)	Either enter the no. of depreciation years or the depreciation ending date.
70 Default Depreciation Book		Boolean	Populate this if you are importing more than one depreciation book record for an asset.