Department Import
Departments can be used to categorize records, such as accounts, employees, and items. Departments usually indicate groupings of records according to management responsibility. For more information, see Creating Departments.
You can use the Import Assistant to set up and update department records in your NetSuite account. To import department records, select Classification as the import type, and Department as the record type.
Before you can import departments, an administrator, or another user with permission to enable features, must go to Setup > Company > Enable Features, and on the Company subtab, check the Departments box and click Save.
Department fields for which data can be imported include Name, External ID, Subdepartment of (the parent department, if any), and whether the department is inactive. If you are using NetSuite OneWorld, these additional fields also are available: Subsidiaries (the subsidiaries associated with a department), and Include Children (a Boolean indicating whether to associate a department with all child subsidiaries of those specified in the Subsidiaries field).
For details about fields that can be mapped in the Department record, see the SOAP Schema Browser’s department reference page. You can use the field definitions here as a basis for creating your own CSV import template file. For information about working with the SOAP Schema Browser, see SOAP Schema Browser.
After you have imported department records successfully, you can review them at Setup > Company > Departments.
If you plan to import other record types that include fields referencing department values, complete the import of departments first.
The Import Assistant is available at Setup > Import/Export > Import Tasks > Import CSV Records. After you Select a Record Type for Import, Choose Import Character Encoding.