1. NetSuite Connector
  2. Managing NCP Connectors
  3. Salesforce Connector
  4. Managing the Salesforce Connector in NetSuite Connector Platform
  5. Troubleshooting Salesforce Connector Issues
  6. Troubleshooting Salesforce Connector Data Sync Issues

Troubleshooting Salesforce Connector Data Sync Issues

Entity

Issue

Probable Root Cause

Resolution

Item

The item is created in NetSuite but not synced to Salesforce.

Item Sync is not enabled in data syncs page.

  • Enable data sync

  • Ensure User Event script is active – In NetSuite, go to Customization > Scripting > Scriptsa and Customization > Scripting > Script Deployment of the inventory item and ensure that it is enabled.

Item

Item created in NetSuite with price details but failed to sync to Salesforce.

Error code: ORCL-BA-NS2SFDC_INVITEM_CREATE_ERROR : Missing Pricebook lookup or lookup is not configured for all defined levels.

The price book lookup is not configured.

Configure the price book lookups in Connector Platform > Settings > Manage Lookups. You need to configure the NetSuite Price Levels lookup.

Item

Product creation failed in Salesforce.

This issue can occur due to the following:

  • Tax schedule is not configured in NetSuite Custom Preferences.

  • Product type not selected while creating the product.

  • Configure the tax schedule in the Default Tax Schedule section in Connector Platform > Settings >Preferences.

  • Ensure that the created product has a product type selected.

Item

Inventory item creation failed in Salesforce.

Default asset and cogs accounts are not configured in NetSuite.

Go to Setup > Accounting > Accounting Preferences. Configure COGS and Asset Account on the Items/Transactions tab.

Opportunity

Opportunity Sync from Salesforce to NetSuite failed.

Error: SalesOrder Create Failed in NetSuite. Details : Invalid item reference key number for subsidiary number.

Raw Error on Error report:

Invalid item reference key number for subsidiary number.Error : Update Opportunity Sync Failure Status Failed in Salesforce

ORCL-BRT-OPPORTUNITY2SALESORDER_FAULT

Subsidiary added to Account is different from Subsidiary added to attached Product.

Ensure that the product and account are under the same subsidiary.

Opportunity

Opportunity Sync failed from Salesforce to NetSuite

Detailed error: - Received a SOAPFault while invoking URL due to "INVALID_TYPE: sObject type 'ContentNote' is not supported."

Notes is not enabled in Salesforce Opportunity layout.

Go to Salesforce and enable Notes in Notes Settings.

All

Sub Sync is failed with below error :

Currency ISO Code: invalid currency code: -1

Currency table is not configured in lookup table.

Update Currency Codes lookup table, then retry the failed sync.

All

Item Sync failed with below error:

Record rolled back because not all records were valid and the request was using AllOrNone header

Same Salesforce Price Book configured for all the NetSuite Price Levels except Base Price.

Configure different Salesforce price books for each NetSuite Price Level under NetSuite Price Levels lookup.

Mappings

Error: Failed to save Order in Salesforce. Details: CASDK-0033 Received a SOAPFault while invoking {link} due to "'' is not valid for the type xsd:double" CASDK-0033: Received a SOAP fault while invoking endpoint target: {link}. This indicates a processing exception on the service endpoint side. Please check service side logs to further diagnose the problemFault Code : soapenv:ClientFault String : '' is not valid for the type xsd:double

Data entered in unmapped field when sending data from NetSuite to Salesforce

Date conversion is not added to handle null values during mapping of the date field. Contact NetSuite Support to add the mapping support for date fields for NetSuite to Salesforce flows.

General Notices