How to Retrieve Custom Address Field Values from NetSuite Transactions

To retrieve the value of a custom address field from a NetSuite transaction, two primary scripting methods can be employed. It is important to note that the following examples utilize SuiteScript 1.0 APIs, which are deprecated. For new development, NetSuite recommends using SuiteScript 2.x.

1. Retrieve the custom field value by loading the subrecord within the customer record:

   This method involves loading the transaction record, identifying the associated customer and address ID, and then iterating through the customer's address book sublist to locate the specific address and extract the custom field value from its subrecord.

javascript
    var transactionRecord  nlapiLoadRecord('salesorder', 554395);
    // This should work also when using shipaddresslist
    var addressRecordId  transactionRecord .getFieldValue('billaddresslist');
    var customerRecord  nlapiLoadRecord('customer',
    transactionRecord.getFieldValue('entity'));
    var customFieldValue  null;
    for (var i  1; i < customerRecord.getLineItemCount('addressbook'); i++)
    {
        customerRecord.selectLineItem('addressbook', i);
        var id  customerRecord.getCurrentLineItemValue('addressbook', 'id');
        if (id  addressRecordId)
        {
            var subrecord
    customerRecord.viewCurrentLineItemSubrecord('addressbook',
    'addressbookaddress');
            customFieldValue  subrecord.getFieldValue('custrecord_contact_id');
        }
    }

1. Create a search to get the value of your custom field:

   This approach leverages NetSuite's search capabilities to directly query for the transaction and join to its billing address, allowing for the extraction of the custom field value in a more streamlined manner.

javascript
    var filters  [];
    filters.push(new nlobjSearchFilter('internalid', null, 'anyof', 554395));
    filters.push(new nlobjSearchFilter('mainline', null, 'is', 'T'));
    var searchResults  nlapiSearchRecord('salesorder', null, filters, new
    nlobjSearchColumn('custrecord_contact_id', 'billingaddress'));
    var customFieldValue
    searchResults[0].getValue('custrecord_contact_id', 'billingaddress');