Map address between NetSuite and Salesforce

The Integration App uses data flows to transfer data between two apps that you’re integrating. The data comes from the values populated in each field on a record. For every field that’s present on a record in Salesforce, there will be a substitute field on a NetSuite record.

Example: You can sync data for a Billing Address in NetSuite to Address Line 1 and 2 fields to Salesforce Billing Address. However, the format for storing addresses between Salesforce and NetSuite is different. The Integration App allows you to sync data by mapping fields in NetSuite with those in Salesforce.  

You can map Mailing, Billing, and Shipping Addresses between NetSuite and Salesforce. NetSuite stores an address in multiple Address Lines 1, 2, and 3. By default, NetSuite allows you to split and store Billing, Mailing, and Shipping Addresses in Address Lines 1 and 2. Additionally, you can configure NetSuite to split and store these addresses in Address Lines 1, 2, and 3.

To map Address Lines from NetSuite to Salesforce Address,  you’ll need to use an expression in your flow mappings.

Navigate to flow field mappings

To navigate to field mappings for a flow:

1. Login to your integrator.io account.
2. Click on your Salesforce-NetSuite IO integration tile.
3. From the settings navigation pane to the left, click on a flow under Integration flows.
4. Click on field mappings next to a flow name to open up the Mappings dialogue box.

Map NetSuite export fields to Salesforce import fields

Read more to know about mapping fields between NetSuite and Salesforce. To configure field settings ( icon next to a field), refer to Field Settings.

Map addresses between NetSuite and Salesforce

• Notes:
  • You can map and sync Billing, Mailing, and Shipping Addresses from NetSuite Address Lines to Salesforce Address.
  • This feature is available for Addresses in Account and Contact records.
    

Map NetSuite Address Lines to Salesforce Address

• Note: We’ve used a Shipping Address for illustrative purposes. The process for mapping the Billing and Mailing Address remains the same.

To sync NetSuite Address Line 1 to Salesforce Shipping Address:

1. Refresh  the “Export Field (NetSuite)” and “Import Field (Salesforce).“
2. Map Shipping Street export field to shipaddr1 import field.
3. Click Save.

Map NetSuite Address Lines 1 & 2 to Salesforce Address

• Notes: 
  • We’ve used a Shipping Address for illustrative purposes. The process for mapping the Mailing and Billing Addresses remains the same.
  • If you map addresses from NetSuite to Salesforce, the Integration App merges and syncs NetSuite Address Line 1 and 2 to an Address in Salesforce.

To merge and sync NetSuite Address to Salesforce Address:

1. Refresh  the “Export Field (NetSuite)” and “Import Field (Salesforce).“
2. Map shipaddr1 and shipaddr2 export fields to the Shipping Street import field.
3. Click field setting next to Shipping Street.
   1. From the settings box, select “Multi-Field.”
   2. Enter the value mentioned below into the Expression text box:
      {{shipaddr1}}
      {{shipaddr2}}
      
      • Notes:
        • We’ll split the address into two separate lines in Salesforce if you use the expression 
          {{shipaddr1}}
          {{shipaddr2}}
        • We’ll split the address in a continuous line, if you use the expression {{shipaddr1}}{{shipaddr2}}
   3. Click Save.
4. Click Save.

Map NetSuite Address Lines 1, 2, & 3 to Salesforce Address

• Note: We’ve used Shipping Address for illustrative purposes. The process for mapping the Billing and Mailing Addresses remains the same.

To merge and sync NetSuite Address Lines 1, 2, and 3 to Salesforce Address:

1. Refresh  the “Export Field (NetSuite)” and “Import Field (Salesforce).“
2. Map shipaddr1, shipaddr2, and shipaddr3 export fields to the Shipping Street import field.
3. Click field setting next to Shipping Street.
   1. From the settings box, select “Multi-Field.”
   2. Enter the value mentioned below into the Expression text box:
      {{shipaddr1}}
      {{shipaddr2}}
      {{shipaddr3}}
      • Notes:
        • We’ll split the address into three separate lines in Salesforce if you use the expression  {{shipaddr1}}
          {{shipaddr2}}
          {{shipaddr3}}
        • We’ll split the address in a continuous line, if you use the expression {{shipaddr1}}{{shipaddr2}}{{shipaddr3}}
   3. Click Save.
4. Click Save.

Check out our community forum to ask questions and get insightful tips on field mappings from our community members.