NSC | Import FAM Alternate Depreciation > Resolve Error: Field not Mapped / Empty

Micah Timbol-Oracle

Scenario:

The user is attempting to update an existing FAM Alternate Depreciation record via CSV Import. During the import process, However the system returns the following error message:

Could not find matching record. Primary name field was not mapped or is empty.

This error indicates that the system could not identify the target record due to a missing or improperly mapped Internal ID, which is required when performing update operations.

Solution:

The CSV file used for the update must include the following columns with appropriate data:

• Internal ID: Enter the Internal ID of the existing FAM Alternate Depreciation record that is to be updated.
• Book Value (NBV): Input the asset's Book Value based on the mid-life asset's value as of the import date.
• Last Depreciation Date: Provide the date that reflects the last depreciation date of the mid-life asset.
• Last Depreciation Period: Specify the number of periods the asset has been depreciated up to the import date.
• Last Depreciation Amount: Include the amount from the most recent depreciation event on the mid-life asset.

In this scenario, the details are the following:

• Book Value (NBV): 10,000
• Last Depreciation Date: 01/15/2025
• Last Depreciation Period: 18
• Last Depreciation Amount: 555.55

The corresponding CSV file should look like this:

Follow these steps to upload and process the CSV file:

1. Navigate to Setup > Import/Export > Import CSV Records
2. In the Scan & Upload CSV File step, set the following:
   • Import Type: Custom Record
   • Record Type: FAM Alternate Depreciation
3. Click Next to proceed
4. On the Import Options page:
   • Set Data Handling to Update
   • Under Advanced Options, enable the checkbox for Run Server SuiteScript and Trigger Workflows
5. Click Next
6. On the Field Mapping step:
   • Map each column from your CSV file (under "Your Fields") to the appropriate NetSuite fields
   • Confirm that Internal ID is correctly mapped to the NetSuite Internal ID field
7. Click Next
8. Provide a name for the import in the Import Name field
9. Click Save & Run to begin the update process

After uploading and mapping this file through the import wizard with the Update data handling option, the system will apply the changes to the specified FAM Alternate Depreciation record.

Hope this helped!