Custom Shipping and Billing

Sales order creation in NetSuite does allow for custom shipping and custom billing addresses, and addresee.

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.

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.

In the above examples you can see the formula is concatenating the First and Last Names from the contact record. The added IF statement is used to determine if a blank space is needed between the two fields, which only occurs when there is data in the First name. This avoids the problematic addition of a leading space when only Last Name is present.