Updating Tax Methods

Updating the tax methods is an optional step that is required only if the imported mid-life assets are linked to asset types with default tax methods (alternate depreciation). When asset records are created through CSV import, the default tax methods associated to asset types are also imported. Some fields for the tax methods, however, are not populated. You must perform another import to update the fields with missing values.

Step 1: Create saved search and export to a CSV file

1. Create a saved search as follows:

   1. Go to Lists > Search > Saved Searches > New.

   2. Select FAM Alternate Depreciation.

   3. Enter a new search title.

   4. On the Criteria subtab, select date created.

   5. On the Results subtab, add the following fields:

      • Internal ID

      • Asset Status

      • Last Depreciation Date

      • Last Depreciation Period

      • Last Depreciation Amount

      • Book Value (NBV)

   6. On the Available Filters subtab, add your required filters.

   7. Click Save & Run.

2. On the saved search results, click Export - CSV to export the Search results as a CSV file.

3. In the exported CSV file, check that the values of the tax methods you are updating are correct. Make any necessary corrections to your file before importing it.

Step 2: Import CSV File as Alternate Depreciation

1. Go to Setup > Import/Export > Import CSV Records.

2. In the Import Assistant – Scan & Upload CSV File screen, do the following:

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

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

   3. Select your CSV file, and then click Next.

3. In the Import Assistant – Import Options screen, set Data Handling to Add or Update, and then click Next.

4. In the Import Assistant – Field Mapping screen, do the following:

   1. Map the fields in your CSV file to NetSuite fields as follows:

      

   2. Click Next.

      To set default values and reference types on fields, see Setting Default Values and Reference Types.

5. In the Import Assistant - Save Mapping and Start Import screen, do the following:

   1. Enter an Import Map Name and Description.

   2. Click Save & Run.

Related Topics

Setting Up the Fixed Assets Management System

Setting CSV Import Preferences

General Guidelines for Importing Fixed Asset Records

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

Importing Tax Method Depreciation History Records

Setting Default Values and Reference Types

General Notices