Adding Alternate Depreciation Methods Using CSV Import

You can use the CSV import Assistant in NetSuite to update alternate depreciation methods assigned to asset records.

Important:

Before you import asset data, it's best to perform a test import. Create a test CSV file with a few assets and review the formatting 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 isn't checked. If this box is checked, the Cumulative Depreciation, Last Depreciation Date, and Last Depreciation Period will be set to 0 even if your import file includes the correct amounts. 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.

      • Set the Internal ID mapping type to Internal ID.

        Setting the Reference Type to Internal ID
      • Review the CSV fields and NetSuite fields to ensure that all required fields are mapped.

    2. Click Next.

    Example: CSV values

    Sample CSV values

    Example: Mapping

    Sample field 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

General Notices