Home Recent Sign up Sign in

 

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.

 

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

##"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:

##IF(EQUALS(BEFORE(BillingStreet,'<10>'),''),BillingStreet,POSTDEL(BEFORE(BillingStreet,'<10>'),'<13>'))

Address

 

##IF(EQUALS(BEFORE(BillingStreet,'<10>'),''),'',AFTER(BillingStreet,'<10>'))

Address 2

 

Above, the first field is on the Source side (left side) and the second line is on the Destination side (right side) in the Field List mapping.