Adding Alternate Depreciation Methods Using CSV Import

In the Fixed Assets Management SuiteApp, you can use the CSV import Assistant in NetSuite to update alternate depreciation methods assigned to asset records.

Important:

Before you attempt to import asset data, it is best to perform a test import to verify that your CSV import works without errors. Set up a test CSV file of a few assets and review the formatting carefully to ensure that data is imported with correct values.

To add alternate depreciation methods to asset records using CSV import:

1. Prepare an Import File by creating a custom view from the existing Fixed Asset list in NetSuite.

   1. Go to Fixed Assets > Lists > Assets.

   2. Click Customize View.

   3. Set Criteria to filter the list as necessary.

   4. Choose the fields to be updated and add them to the Results subtab of the new custom view.

      To see the necessary fields to be imported, read FAM Alternate Depreciation Sublist.

      Important:

      The Asset's NetSuite Internal ID is required to link the updated information to the correct asset.

   5. Click Preview.

   6. Click Export - CSV and save the CSV file.

2. On Fixed Assets > Setup > System Setup, make sure that the Run Server Scripts on CSV Import box is not checked. If this box is left checked then information such as Cumulative Depreciation, Last Depreciation Date, and Last Depreciation Period will be auto-populated with default values of 0 even if true amounts are included in the import file. For more information, see General Guidelines for Importing Fixed Asset Records.

3. Go to Setup > Import/Export > Import CSV Records. In the Import Assistant Step 1 - Scan & Upload CSV File screen:

   1. From the Import Type list, select Custom Records.

   2. From the Record Type list, select FAM Alternate Depreciation.

   3. Select the CSV file to upload.

   4. Click Next.

4. In the Import Assistant Step 2 - Import Options screen:

   1. Set Data Handling to Add.

   2. Click Next.

5. In the Import Assistant Step 4 - Field Mapping screen:

   1. Map the fields in your CSV file to the NetSuite fields.

      • Make sure that the Internal ID mapping type is set to Internal ID.

        

      • Review the CSV fields and NetSuite fields to verify that all desired fields are mapped.

   2. Click Next.

   Example: CSV values

   

   Example: Mapping

   

6. In the Import Assistant Step 5 - Save Mapping and Start Import screen:

   1. Enter an Import Map Name and Description.

   2. Click Save & Run.

Related Topics

Fixed Assets Management Overview

Setting Up the Fixed Assets Management System

Alternate Methods (Tax Depreciation Methods)

Creating Asset Records through CSV Import

Updating Asset Records Using CSV Import

Manually Editing Asset Records

Restricting the Editing of Asset Values

Adding Tax Depreciation Methods to an Asset

FAM Alternate Depreciation Sublist

Depreciation Methods

Depreciation History Subtab

Triggering the Asset Reset Process

General Notices