Custom Shipping and Billing

sales order creation in netsuite allows for custom shipping, billing addresses, and addressee when utilizing standard salesforce source objects such as order / order product, you may find standard fields such as billingaddress and shippingaddress, whose individual parts are not readily shown, can be used as shown below curl addresses \&billing addressee=bw bill to contact c \&billing addr1=billingstreet \&billing city=billingcity \&billing state=billingstate \&billing country=billingcountry \&billing zip=billingpostalcode \&shipping addressee=bw ship to contact c \&shipping addr1=shippingstreet \&shipping city=shippingcity \&shipping state=shippingstate \&shipping country=shippingcountry \&shipping zip=shippingpostalcode for lookup fields to contact records, for bill and ship to contact, you may need to make a formula field which properly creates a single text field from the separate first name and last name fields shown above as bw bill to contact c they are just text formula fields curl addresses formula for bill to contact billtocontact firstname & if(or(isblank(billtocontact firstname),isnull(billtocontact firstname)), ""," ") & billtocontact lastname formula for ship to contact shiptocontact firstname & if(or(isblank(shiptocontact firstname),isnull(shiptocontact firstname)), ""," ") & shiptocontact lastname in the above examples, the formula concatenates the first and last names from the contact record the added if statement determines if a blank space is needed between the two fields, which only occurs when data is in the first name this avoids the problematic addition of a leading space when only the last name is present