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.
Settings
Update Existing
| Value | Description |
|---|---|
| Yes | Update existing records and add new records. |
| No | Only add new records. |
Balances Journal Type
| Value | Description |
|---|---|
| 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 Journal | Import the opening balances to a Fixed Asset G/L Journal. |
Example: Importing a Fixed Asset Register for a new Company
In this example, we use Excel Importer to upload a fixed asset register that contains the the fixed assets together with the the cost and accumulated depreciation.
Excel file
