---
title: "How To map customer address between MS Dynamics NAV and Salesforce.com"
description: "How To map customer address between MS Dynamics NAV and Salesforce.com"
keywords: "map address NAV Salesforce.com"
url: "https://myrapidi.com/wiki/how_to_map_customer_address_between_ms_dynamics_nav_and_salesforce_com"
locale: "en"
published: "2009-05-08T06:19:04Z"
modified: "2025-11-30T18:21:28Z"
---

### Overview

- A Customer address in Navision (or MS Dynamics NAV) is generally in two different fields: "Address" and "Address 2".
- In Salesforce.com the address is in one field called BillingAddress or ShippingAddress.
- You may use the illustrations below in Field List mapping to format the address when transfer data from and to MS Dynamics NAV to Salesforce.com.

In a Transfer going from MS Dynamics NAV to Salesforce.com, use the following in the Field List:

| Source Field | Dest. Field |
| --- | --- |
| ##"Address"+IF(EQUALS("Address 2",''),'',PREPEND("Address 2",'\<13,10\>',LENGTH("Address 2")+2)) | BillingStreet |
In a Transfer going from Salesforce.com to MS Dynamics NAV, use the following in the Field List:  
  

| Source Field | Dest. Field |
| --- | --- |
| ##IF(EQUALS(BEFORE(BillingStreet,'\<10\>'),''),BillingStreet,POSTDEL(BEFORE(BillingStreet,'\<10\>'),'\<13\>')) | Address |
| ##IF(EQUALS(BEFORE(BillingStreet,'\<10\>'),''),'',AFTER(BillingStreet,'\<10\>')) | Address 2 |