Applies To
Product: NetSuite 2022.1
Scenario
Users wanted to add Subsidiary to Customer Record via CSV Import.
Solution
1. Create a CSV file with the following information:
- Customer Internal ID
- Subsidiary Name
2. Navigate to Setup > Import/Export > Import CSV Records
3. Import Type : Select Relationships
4. Record Type : Select Customer-Subsidiary Relationship
5. Select File to upload
6. Click Next
7. Data Handling : Select Add
8. Click Next
9. Your Fields : Select Customer Internal ID – Netsuite Fields : Select Customer-Subsidiary relationship : Customer (Req)
10. Your Fields : Select Subsidiary Name – Netsuite Fields : Select Customer-Subsidiary relationship : Subsidiary (Req)
Note: Click the pencil icon for Customer Internal ID, select Internal ID in the Choose Reference Type dropdown field, click OK.
11. Click Next
12. Import Map Name : Enter Name
13. Click Save & Run