General Guidelines for Importing Fixed Asset Records
-
Import the asset record data first, then import the depreciation history data.
-
Asset Type is a required field for FAM asset and asset depreciation history imports.
-
The Subsidiary field is a required field for FAM asset and asset depreciation history imports when you're importing data into a OneWorld account.
-
Map the NetSuite Subsidiary field to a field in your CSV file. Otherwise, the import fails.
-
Enter the subsidiary values in this format: Grandparent subsidiary : Parent subsidiary: Child. For example, Consolidated Parent Company : UK Subsidiary : Euro Subsidiary.
-
-
The Currency Id field is required for FAM asset imports if Multiple Currencies is enabled. The Currency Id is the internal ID of the subsidiary’s base currency. To determine the internal ID of a currency, go to Lists > Accounting > Currencies.
-
Location, Department, and Class are required for FAM asset imports when these fields are mandatory on a journal entry.
-
If the Prior Year Net Book Value is not equal to the Asset Original Cost:
-
Set the Asset Original Cost to an amount equal to the Prior Year Net Book Value, then import the asset record.
-
If you're also adding alternate depreciation for mid-life assets, import the alternate depreciation method. This action copies the Asset Original Cost to the asset record, and sets the Prior Year Net Book Value for both the asset and the alternate depreciation method.
-
After you import the asset records, run another import to update the Asset Original Cost to the correct amount. If you added an alternate depreciation, run another import to update the Asset Original Cost on the alternate depreciation method record.
-
-
You don't have to follow the system generated naming format for depreciation history records. Use any value in the Name field (in the CSV file) to identify the depreciation period for the depreciation history records you're importing. Avoid using a “|” separator in the name. Otherwise, the record won't appear in depreciation searches.
-
To expose all fields for import, set the preferred form for FAM Asset and FAM Asset Depreciation History to the standard form. Go to Customization > Lists, Records, & Fields > Record Types and click a record. Click the Forms tab and check the standard form. To maintain data integrity, reset the preferred form back to the custom form when imports are complete.
-
When upgrading to a OneWorld account, the system doesn't automatically populate the values in the asset record’s Subsidiary field. You can update the asset record using CSV import. You must manually add a value for the subsidiary before importing the CSV file. Alternatively, you can contact NetSuite Professional Services for help with data migration.
Related Topics
- Setting Up the Fixed Assets Management System
- Setting CSV Import Preferences
- Guidelines for Importing Mid-life Asset Records
- Guidelines for Importing Fully Depreciated or Disposed Asset Records
- Importing Fixed Asset Records
- Importing Asset Depreciation History Records
- Updating Tax Methods
- Importing Tax Method Depreciation History Records
- Setting Default Values and Reference Types