Articles in this section

Sync Salesforce accounts to NetSuite customers

Courtney Jordan
Updated

The Salesforce Account to NetSuite Customer Add/Update flow is a real-time flow that lets you sync the Salesforce Accounts updates to NetSuite Customers provided the Account has at least one "Closed Won" Opportunity associated with it.

Any errors will be displayed on the dashboard.

SFNSIO_acct-to-cust-7.png

Sync new Salesforce accounts to NetSuite customers

  1. An Account is created or updated in Salesforce.

  2. If the Account has a Closed Won Opportunity, the fl ow first checks using the Primary lookup Criteria, by matching the Salesforce ID, and then using the Secondary lookup Criteria, which is a customizable field.

  3. If not found, Celigo creates a new Customer in NetSuite.

  4. If found, Celigo updates that Customer in NetSuite.

  5. The Sync Salesforce Opportunity to NetSuite Sales Order Add/Update flow will then sync Opportunities as Sales Orders in NetSuite

Important

In the Salesforce account to NetSuite customer Add/update flow, add the mapping handleStateCode : false only when you configure a conditional mapping of state fields. For example, in the field mappings, if the state field Advanced setting is selected as Creating a record, with the handleStateCode : false mapping, the flow syncs only the records created and will not consider any updated records.

If you want the flow to sync both created and updated information of state fields, do not add the handleStateCode mapping or make any selections in the state fields Advanced section.

Image1.png

Once the Customer is created, any subsequent updates to Accounts are automatically synced to NetSuite Customer.

The flow syncs the parent-level information for a Salesforce Account. For example, if a company ABC has its parent company named XYZ, when the flow runs, the Account information for XYZ will be synced as well.

Sync existing Salesforce Accounts to NetSuite Customers

You'll need to manually add Closed Won Opportunities to existing Salesforce accounts to create them as Customers in NetSuite.

Existing Salesforce Accounts already synced to NetSuite Customers

For an existing Salesforce Account that is already synced to NetSuite, if you add a parent account in Salesforce, the parent account will not be synced to NetSuite.

Parent Accounts created after child Accounts

If a parent Account is created after the child Accounts have already been synced with NetSuite, the parent will not be synced to NetSuite unless the user performs force sync.

Salesforce Account to NetSuite Customer

  1. In the integration tile, click the gear icon.

  2. Go to Settings > Integration Flows > Account

  3. Turn on the Salesforce Account to NetSuite Customer flow using the toggle switch.

  4. In your Salesforce Account, go to Accounts.

  5. From the available list of Accounts, click the desired account.

  6. Click Edit .

  7. Make the desired updates and click Save .

If everything is configured correctly, the details that you updated in the Account will be automatically synced to Customers in NetSuite.

Note

Note : You can modify the criteria for Account sync using the Settings icon of the flow.

Trigger flow

To trigger the flow, you'll need to define your criteria:

  1. Go to Settings > Integrations Flows > Opportunity > Salesforce Account to NetSuite Customer .

  2. Click the Settings icon that corresponds to the flow.

  3. Click the Qualification Criteria button.

  4. Select the desired values for setting your own criteria for triggering the flow.

  5. Click Save and then click Save again.

Note

Note : By default, for an Account to sync as Customer the NetSuite ID field of Account should not be NULL.

Supported features

  • Multi-Subsidiary. The synced subsidiary can be found under the Subsidiaries subtab of NetSuite Customer.

  • Multi-Currency. The synced currency can be found under the Currency subtab of the NetSuite Customer.