Required Fields on Records
Some NetSuite fields are required, so you have to give them a value or the import won’t work. You can map these fields to your CSV columns or set default values for them on the Field Mapping page.
Required NetSuite fields show up in the NetSuite Fields column with (Req) after their name. Usually, they’re listed automatically in the mapping pane to remind you to map them. But if a required field is hidden in a tree node on the right, you’ll need to click it and map it yourself. Required fields for sublists work a bit differently; for information see Required Fields for Sublist Import Mapping.
Mapping a Required Field
-
On the Field Mapping page, click the required NetSuite field on the right if it is not already in the mapping column.
-
Click the matching field from your CSV on the left to map it to the NetSuite required field.
Providing a Default Value for a Required Field
-
Click the edit icon next to your field.
-
Enter a default value for this field.
For more information, see Assign Default Values during Field Mapping.
Even if you set a default value for fields in a sublist, no sublist data gets imported unless you map at least one field for that sublist. For more information about working with sublists, see Sublist Data Import.
If Marketing Automation is enabled and you choose the “Add” data handling option on the Import Assistant's Import Options page, you will be required to map the Unsubscribe field on the Field Mapping page, even if this field is not displayed on your preferred form for the record type. If the Unsubscribe field has not been mapped to a value, an error is thrown and you must go back and rectify the error.