NetSuite - Custom Fields - Linked to Address Book but Inaccessible through JavaScript

Question

NetSuite - Custom Fields - Linked to Address Book but Inaccessible through JavaScript

Currently in the process of creating a Sales Order script to extract a custom field linked to the chosen shipping address. While I have successfully retrieved all address fields (such as city and zip), I am facing challenges when attempting to access any custom fields associated with the address.

Here's an example of the script:

var custid = document.getElementById("hddn_entity_fs").value;
var shiptoid = document.getElementById("hddn_shipaddresslist2").value;

var customer = nlapiLoadRecord("customer", custid);
var itemCount = customer.getLineItemCount('addressbook');

for (var i = 1; i < itemCount; i++) {
  if (customer.getLineItemValue('addressbook', 'id', i) == shiptoid) {

    //this section functions
    var zip = customer.getLineItemValue('addressbook', 'zip', i);
    console.log('zip:' + zip);

    //the following part encounters issues
    var custrecord19 = customer.getLineItemValue('addressbook', 'custrecord19', i);
    console.log('custrecord19:' + custrecord19);
  }
}

I know there must be a simple solution that I'm overlooking. Any insights or assistance you can provide would be greatly valued!

Sending gratitude your way,

javascript netsuite

Answer 1

Answer №1

Custom fields linked to addresses are stored within the address record itself.

For example, in SS1.0 dynamic mode (which is server-side only), you can access them like this:

var customer = nlapiLoadRecord('customer', custid, {recordmode:'dynamic'});
...
customer.selectLineItem('addressbook', i);
var addr = customer.editCurrentLineItemSubrecord('addressbook', 'addressbookaddress');
console.log(addr.getFieldValue('custrecord19'));

In SS1 server-side scripts that are not dynamic, you would use this approach:

var addr = custRec.viewLineItemSubrecord('addressbook', 'addressbookaddress', i);
console.log(addr.getFieldValue('custrecord19'));

In SS2.0, which works on both client and server side, you can do it like this:

var addr = custRec.getSublistSubrecord({sublistId:'addressbook', fieldId:'addressbookaddress', line:i});
console.log(addr.getValue({fieldId:'custrecord19'}));

An account may utilize a combination of SS1 and SS2 scripts.

To make everything compatible, I recommend converting your current client script to SS2. Here's an outline of a client script:

/**
 * @NApiVersion 2.x 
 * @NScriptType ClientScript
 */
define(['N/currentRecord', 'N/ui/message', 'N/url', 'N/https', 'N/search'],
    function(rec, msg, url, http, search) {



        return {
            fieldChanged : function(){ console.log('fired field changed');},
            postSourcing: function(){ console.log('fired sourcing');}
        };
    });

Answer 2

Custom fields linked to addresses are stored within the address record itself.

For example, in SS1.0 dynamic mode (which is server-side only), you can access them like this:

var customer = nlapiLoadRecord('customer', custid, {recordmode:'dynamic'});
...
customer.selectLineItem('addressbook', i);
var addr = customer.editCurrentLineItemSubrecord('addressbook', 'addressbookaddress');
console.log(addr.getFieldValue('custrecord19'));

In SS1 server-side scripts that are not dynamic, you would use this approach:

var addr = custRec.viewLineItemSubrecord('addressbook', 'addressbookaddress', i);
console.log(addr.getFieldValue('custrecord19'));

In SS2.0, which works on both client and server side, you can do it like this:

var addr = custRec.getSublistSubrecord({sublistId:'addressbook', fieldId:'addressbookaddress', line:i});
console.log(addr.getValue({fieldId:'custrecord19'}));

An account may utilize a combination of SS1 and SS2 scripts.

To make everything compatible, I recommend converting your current client script to SS2. Here's an outline of a client script:

/**
 * @NApiVersion 2.x 
 * @NScriptType ClientScript
 */
define(['N/currentRecord', 'N/ui/message', 'N/url', 'N/https', 'N/search'],
    function(rec, msg, url, http, search) {



        return {
            fieldChanged : function(){ console.log('fired field changed');},
            postSourcing: function(){ console.log('fired sourcing');}
        };
    });

NetSuite - Custom Fields - Linked to Address Book but Inaccessible through JavaScript

Answer №1

Similar questions

Shadows on menu buttons transform when clicked using React and CSS

Having trouble launching my Angular project

Unexpected behavior encountered with JQueryUI modal functionality

Extract the value from JSON data

The focus is being lost on the ng-model when used within an ng-repeat

Refresh text displayed on a button with the help of setInterval

Transforming a dynamic background image into dynamic HTML elements

What is the best way to trigger the download of an image file created by PHP to a user's computer?

Using a JavaScript command, connect a function from one file to another file

Tips for utilizing a Three.js curve to guide the movement of a mesh along a specified path

Modify the href attribute of an anchor tag that does not have a specified class or

Connecting extra parameters to an event listener

Firebase User Becomes Undefined Upon Refreshing the Web Page

Are your GetJSON requests failing to execute properly?

What is the best way to dynamically change the color of my component depending on the prop passed to it?

Can you explain the significance of the colon in this context?

How to Set Up a Simple Gulp Uglify Configuration

Utilizing Angular2 to access NPM package (Googleapis)

Utilizing external functions in Node.js by importing them from different files

Error: Attempting to assign a value to property 'x' of an undefined object has resulted in a TypeError