Import Preference for New Assets
If we are importing new assets, set these preferences as follows:
- In Setup > Import/Export > CSV Import Preference, check the Run Server SuiteScript and Trigger Workflows box.
- In Fixed Assets > Setup > System Setup, check the Run Server Script on CSV Import box.
Guidelines for Fixed Asset Import
- Import the asset record data first, and then import the depreciation history data.
- Asset Type is a required field for FAM asset and FAM asset depreciation history imports.
- The Subsidiary field is a required field for FAM asset and FAM asset depreciation history imports when we are importing data into a OneWorld account.
- We must map the NetSuite Subsidiary field to a field in our CSV file. Otherwise, the import fails.
- The value of the subsidiary in the CSV file should be entered in this format: Grandparent subsidiary : Parent subsidiary: Child. For example, Consolidated Parent Company : UK Subsidiary : Euro Subsidiary.
- The Currency Id field is a required field 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, and then import the asset record.
- If we are also adding an alternate depreciation for mid-life assets, import the alternate depreciation method. This copies the Asset Original Cost to the asset record, and sets the amount of the Prior Year Net Book Value for the asset record and the alternate depreciation method.
- After the asset records are imported, perform another import to update the Asset Original Cost to the correct amount. If we added an alternate depreciation, perform another import to update the Asset Original Cost on the alternate depreciation method record.
- We do not have to follow the format of the system generated name for the depreciation history record. We can use any value for the Name field in the CSV file to identify the depreciation period for the depreciation history records we are importing. Avoid using a “|” separator in the name so that the record will not be picked up in the depreciation search.
- To expose all fields for import, set the preferred form for both 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 does not automatically populate the values in the asset record’s Subsidiary field. We can update the asset record using CSV import. We must manually add a value for the subsidiary before importing the CSV file. Alternatively, we can also contact NetSuite Professional Services to assist us with data migration.