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.

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, 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.