NetSuite Subsidiary Sync to Salesforce

To better understand the Subsidiary sync, we first need to define some terms:

NetSuite OneWorld accounts let you manage data for this hierarchical structure of subsidiaries, which are separate legal entities. The parent subsidiary is the highest-level in the NetSuite account, and all other subsidiaries are children of the parent.

Each subsidiary represents a separate company within the global organization. Subsidiaries can be international or domestic. When you create a subsidiary record in NetSuite, the country you define for its address determines the NetSuite edition and tax nexus associated with that subsidiary.

For more information, see Subsidiaries in OneWorld. The internal ID for this NetSuite record is subsidiary.

About the Subsidiary Sync

Salesforce does not have an equivalent to the NetSuite concept of subsidiary. The Subsidiary sync populates the NetSuite-required subsidiary information in Salesforce. This sync associates the correct subsidiary with a Salesforce Account.

                                                                                                                                                                                                                                                                                     

Subsidiary records are maintained in NetSuite. To ensure that Customer records are always created with the correct subsidiary, an accurate subsidiary list must be available in Salesforce:

  • During the creation of a Customer record in NetSuite from a Salesforce Account.

  • When an existing NetSuite Subsidiary record is updated, it must be synced to Salesforce.

The Subsidiary sync is triggered when the following conditions are met:

  • When creating a new Subsidiary record in NetSuite.

  • When an existing Subsidiary record is updated in NetSuite.

For successful Subsidiary syncs, you will see Operation Succeeded in NetSuite, and the sync status will be Completed.

If this sync fails, you will see an appropriate status message in both NetSuite and Salesforce.

The following tables show the mapping between NetSuite Subsidiary fields and Salesforce Subsidiary fields to ensure that identical data is maintained in both applications.

Custom Subsidiary Field Mapping

NetSuite Subsidiary Fields

Salesforce Subsidiary Fields

Subsidiary name

Oracle NetSuite Subsidiary Name

Subsidiary Id

Oracle NetSuite Subsidiary Oracle_NetSuite_ID__c

Subsidiary Currency

Oracle NetSuite Subsidiary CurrencyIsoCode

Subsidiary isActive

Oracle NetSuite Subsidiary Active__c

Subsidiary/custrecord_oracle_salesforce_id

Oracle NetSuite Subsidiary Id

Subsidiary custrecord_oracle_sfdc_sub_create_status

Subsidiary custrecord_oracle_subsdry_sync_message

General Notices