ANS-1041 · CSV IMPORT & DATA MIGRATION
Why Are Custom Fields Missing in NetSuite CSV Import Mapping?
Custom fields may not appear during NetSuite CSV import mapping if the incorrect custom form is selected in the import options, impacting data synchronization.
Short answer
Custom fields in NetSuite CSV imports are tied to the custom form selected in Step 2 (Import Options). If a custom field isn't visible in Step 4 (Field Mapping), ensure you've chosen the specific custom form where that field is applied. This is crucial when importing records like Vendors with multiple custom forms.
Scenario
Users attempting to import data via CSV in NetSuite may encounter situations where custom fields, which are expected to be available for mapping, do not appear in Step 4 of the CSV import process. This often occurs when importing record types such as Vendors, where multiple custom forms might be in use, leading to confusion about field visibility.
Solution
During the NetSuite CSV import process, the custom fields available for mapping in Step 4 (Field Mapping) are determined by the custom form selected in Step 2 (Import Options).
If importing records, such as Vendors, where multiple custom forms exist, navigate to the Advanced Options in Step 2.
Ensure that the specific custom form where the desired custom field is applied is selected. Failure to choose the correct form will result in the custom field not appearing in Step 4 for mapping.
Expert NetSuite Support
Need help with this NetSuite issue?
CSV Import & Data Migration consulting and configuration support