General CSV Field Mapping Tips

• If you’re using NetSuite OneWorld, you have to map the Subsidiary field for these record types: Chart of Accounts, Contacts, Customers, Employees, Jobs (Projects), Leads, Partners, Prospects, and Vendors. If you try to import or update records without a subsidiary, the import will fail.

• The NetSuite fields you see in the right pane depend on what’s available on your preferred form for that record type. If your form doesn’t allow access to certain fields, you won’t see them for mapping.

  If you use a custom form for data entry in the user interface, you can select that form as an advanced option on the Import Options page to make sure the right fields are available for mapping. By default, the standard form is used. For more info, see .

• You can map one CSV field to multiple fields in the same NetSuite record or sublist.

• If you don’t map any fields for a sublist, no sublist data gets imported, even if you set a default value for some sublist fields. For more info about sublist data and the Import Assistant, see Sublist Data Import.

• If you want to create your own CSV import templates that map to NetSuite fields automatically, check the SOAP Schema Browser for field details by record type. For information about working with this tool, see the help topic SOAP Schema Browser.

General Notices