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.
Issue:Updates on the Salesforce Opportunities that are synced to the NetSuite Sales Orders are creating duplicate Sales Order Lines.
Resolution:
The first thing to check is to see if the Sales Order form being used has the Salesforce Line ID column field hidden on the Sales Order Lines. This Salesforce Line ID field is what helps the connector find and update existing Sales Order Lines.
If a column field on any record type in NetSuite is hidden, the Connector cannot map to it. If the Salesforce Line ID field is hidden, the connector cannot find and update the existing Sales Order Lines, so it creates new ones.
Comments
1 comment
So, this reads, "The first thing to check...." Okay, the field is not hidden. Now what? You also have to specify on the map field-level settings for that SalesForce ID Line to use it as a key field to identify existing records. It's just a check box.
Please sign in to leave a comment.