When location record is synced from one NetSuite to another NetSuite, Address can be fetched using following function. We cannot set location address directly to address field.
/**
* Function to fetch address
* @param {number} recId
* @returns {object}
*/
function address(recId) {
try {
let locationSearchObj = search.create({
type: "location",
filters:
[
["internalid", "anyof", recId]
],
columns:
[
search.createColumn({
name: "address",
join: "address",
label: " Address"
}),
search.createColumn({
name: "address1",
join: "address",
label: " Address 1"
}),
search.createColumn({
name: "address2",
join: "address",
label: " Address 2"
}),
search.createColumn({
name: "address3",
join: "address",
label: " Address 3"
}),
search.createColumn({
name: "addressee",
join: "address",
label: " Addressee"
}),
search.createColumn({
name: "city",
join: "address",
label: " City"
}),
search.createColumn({
name: "attention",
join: "address",
label: " Attention"
}),
search.createColumn({
name: "phone",
join: "address",
label: " Phone"
}),
search.createColumn({
name: "state",
join: "address",
label: " State"
}),
search.createColumn({
name: "zip",
join: "address",
label: " Zip"
}),
search.createColumn({
name: "country",
join: "address",
label: "Country"
}),
search.createColumn({
name: "countrycode",
join: "address",
label: "Country Code"
}),
search.createColumn({
name: "address",
join: "returnAddress",
label: " Address"
}),
search.createColumn({
name: "address1",
join: "returnAddress",
label: " Address 1"
}),
search.createColumn({
name: "address2",
join: "returnAddress",
label: " Address 2"
}),
search.createColumn({
name: "address3",
join: "returnAddress",
label: " Address 3"
}),
search.createColumn({
name: "addressee",
join: "returnAddress",
label: " Addressee"
}),
search.createColumn({
name: "attention",
join: "returnAddress",
label: " Attention"
}),
search.createColumn({
name: "city",
join: "returnAddress",
label: " City"
}),
search.createColumn({
name: "phone",
join: "returnAddress",
label: " Phone"
}),
search.createColumn({
name: "state",
join: "returnAddress",
label: " State"
}),
search.createColumn({
name: "zip",
join: "returnAddress",
label: " Zip"
}),
search.createColumn({
name: "country",
join: "returnAddress",
label: "Country"
}),
search.createColumn({
name: "countrycode",
join: "returnAddress",
label: "Country Code"
})
]
});
let obj = {};
locationSearchObj.run().each(function (result) {
obj.address = result.getValue({
name: "address",
join: "address",
})
obj.address1 = result.getValue({
name: "address1",
join: "address",
})
obj.address2 = result.getValue({
name: "address2",
join: "address",
})
obj.address3 = result.getValue({
name: "address3",
join: "address",
})
obj.addressee = result.getValue({
name: "addressee",
join: "address",
})
obj.city = result.getValue({
name: "city",
join: "address",
})
obj.attention = result.getValue({
name: "attention",
join: "address",
})
obj.phone = result.getValue({
name: "phone",
join: "address",
})
obj.state = result.getValue({
name: "state",
join: "address",
})
obj.zip = result.getValue({
name: "zip",
join: "address",
})
obj.country = result.getValue({
name: "countrycode",
join: "address",
})
obj.raddress = result.getValue({
name: "address",
join: "returnAddress",
})
obj.raddress1 = result.getValue({
name: "address1",
join: "returnAddress",
})
obj.raddress2 = result.getValue({
name: "address2",
join: "returnAddress",
})
obj.raddress3 = result.getValue({
name: "address3",
join: "returnAddress",
})
obj.raddressee = result.getValue({
name: "addressee",
join: "returnAddress",
})
obj.rcity = result.getValue({
name: "city",
join: "returnAddress",
})
obj.rattention = result.getValue({
name: "attention",
join: "returnAddress",
})
obj.rphone = result.getValue({
name: "phone",
join: "returnAddress",
})
obj.rstate = result.getValue({
name: "state",
join: "returnAddress",
})
obj.rzip = result.getValue({
name: "zip",
join: "returnAddress",
})
obj.rcountry = result.getValue({
name: "countrycode",
join: "returnAddress",
})
});
return obj;
} catch (error) {
log.error('Error @ address', error);
}
}