Articles in this section

Sync Salesforce accounts to NetSuite customers

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.

Was this article helpful?
0 out of 0 found this helpful

Comments

6 comments
Date Votes
  • We are quoting out of NetSuite.  We don't want to create a closed won opportunity just to have the prospect sync over to NetSuite so we can quote...

    0
  • Hello Damon, 

    If you just want the Salesforce Accounts sync'd to NetSuite Customers, you may remove the "Field specific qualification criteria" at export, making any create/update operations for Accounts at shall trigger the flow and create/update NetSuite Customer.

    + Nithin Gollapally

    0
  • I've removed the Field specific qualification criteria, but it still only seems to sync from Salesforce to NetSuite if there is a closed-won opportunity.

    0
  • Hi Damon,

    Apologies for the delay in response, Ideally it should sync all the Salesforce Accounts created irrespective of Qualification criteria (as we have cleared it).

    Can you please confirm, if you have cleared the criteria on Account flow mentioned in the screenshot below?

    If it is yes, please go ahead and raise the celigo support case for further debugging of the behaviour

    Thanks

    0
  • Does the integration app (IO) support filtering on accounts to sync to Netsuite? Could we filter the Salesforce accounts we attempt to sync to Netsuite based on a value of a specific account field (like Status)? 

    0
  • Yes Talroo Inc. Celigo supports this. For instance, at my company, there are several account fields that must be populated to trigger a sync between Salesforce and NetSuite.

    0

Please sign in to leave a comment.