Updating Depreciation History Records through CSV Import

To update depreciation history records through CSV import:

1. Prepare an import file by creating a saved search for depreciation history records.

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

   2. On the New Saved Search page, click the FAM Depreciation History link.

   3. In the Criteria subtab, add the following filters:

      • Accounting Book - Select None to update only the depreciation history records with blank accounting books.

      • Alternate Method – Select None to update only the depreciation history records for the asset's accounting method.

   4. Click Preview, and then export the search results to CSV. For more information, see Exporting Search Results.

   5. Edit the CSV file to add a column for Accounting Book, and then set the value to Primary Accounting Book.

   6. Save the CSV file.

2. Import CSV file for depreciation history record.

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

   2. In the Import Assistant Step 1 – Scan & Upload CSV File screen:

      • From the Import Type list, select Custom Records.

      • From the Record Type list, select FAM Depreciation History.

      • Select the CSV file to upload.

      • Click Next.

   3. In the Import Assistant Step 2 – Import Options screen:

      • Set Data Handling to Update.

      • Click Next.

   4. In Import Assistant Step 4 – Field Mapping screen:

      

      Map the fields in your CSV file to the NetSuite fields. Review the both sets of fields to ensure that all required fields are mapped correctly. Make sure that the Internal ID mapping type is set to Internal ID.

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

      • Enter an Import Map Name and Description.

      • Click Save & Run.

Related Topics