Vendor-Subsidiary Relationship Import
If you use NetSuite OneWorld, the vendor-subsidiary relationship import adds or updates multi-subsidiary vendor records with subsidiary, credit limit, and tax code information. These multi-subsidiary vendor records appear on the Vendors list.
The vendor-subsidiary relationship record is not visible in the user interface. The fields available for mapping appear in the header of the vendor record, and on the Subsidiaries subtab.
Most of the fields are optional in the CSV file.
Following are the fields that are available for CSV mapping:
-
Credit Limit
-
External ID (required)
-
Internal ID
-
Subsidiary
-
Tax Code
-
Vendor (required)
Following is a sample of a newly created multi-subsidiary vendor record.
|
Credit Limit (currency) |
External ID (vendor name) |
Subsidiary (primary and secondary subsidiaries) |
Vendor (company name) |
|
CAD |
More Toys |
More Toys Parent More Toys Australia |
More Toys |
If you want to use Internal ID, follow the sample above and replace the External ID column with Internal ID.
For details about fields that can be mapped in the vendor-subsidiary relationship record, see the SOAP Schema Browser’s vendor-subsidiary relationship 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.
For information about working with multi-select fields in a CSV file, see Delimiters for Hierarchical and Multi-Select Fields.
For information about multi-subsidiary vendors, see Assigning Subsidiaries to a Vendor.