Account or Opportunity sync fails

Note: The name “SmartConnector” will be changing to the “Integration App” to more clearly establish that our pre-built Integration Apps are built on our flagship Integration Platform as a Service, integrator.io. Find out more about integrator.io. 

This article covers possible issues when synching from Salesforce to NetSuite. Let us know if you encounter others so that we can make this article better!

Problem:
I have an Account and Opportunity that fail to get pushed into NetSuite. Whenever I try to push it, it fails immediately or gives me this error message:

'Account does not exist in NetSuite.  Please enable create option from Connector settings or sync Account manually.'

The sync is working for all other accounts and new accounts created after this one. The error is only happening with this one particular account. The push to NetSuite checkbox has not been unchecked since the initial push, even though we have unchecked and saved it several times after the initial pus

Solution:

This error is appearing due to the fact that there was a multi-select field added to the mapping in the flow.  This is not a standard field mapping and has been added to the flow.  The SF Connector does not support multi-select fields because Salesforce stores the value of a multi-select picklist as the semicolon (;) separated and NetSuite stores the multi-select value as comma (,) separated. Since we do not support the multi-select field in the Connector, this field mapping can only be added through customization. 

Customization Options:

1. Create a formula field in Salesforce and store the value of the field "Channel Owner", replaced with a comma, and then use this formula field in the mapping.

2. Create a plugin in NetSuite for the 'Salesforce Opportunity to Sales Order' flow and replace the semicolon with a comma before submitting the record in NetSuite.

Problem:

I get the following error message when trying to sync a Salesforce opportunity to Netsuite as a sales order and have checked Netsuite to ensure that the opportunity owner in Salesforce is marked as a sales rep in Netsuite. 

INVALID_KEY_OR_REF: Import failed for the Salesforce record id: 0063600000gcPX9AAM. Reason: Invalid salesrep reference key 55482.

Solutions:

Reasons for the error can be:
1. Duplicate employee email address (kindly check by searching on global search).
2. An employee record is not set with a Sales Role or is not set as a Sales Rep in NS (see under the Human Resource tab of the employee record) this means that they cannot be set as a Sales Rep