This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Question: I am looking up the location on a sales order from a PO createdfrom id:
var soLookup = search.lookupFields({
                type: search.Type.SALES_ORDER,
                id: relatedSo,
                columns: ‘location’
            });
I expect most of the time for the location to be empty. I keep getting Cannot read property ‘value’ of undefined. How do I test for no results from the lookup? I want that to be a condition but I’m stuck.

Yeah. I tried log but I still get that error:
var soLookup = search.lookupFields({
                type: search.Type.SALES_ORDER,
                id: relatedSo,
                columns: ‘location’
            });
            if(soLookup){
                var soloc = soLookup.location[0].value;
            }
            else{
                var soloc = ‘Empty’;
            }

            log.debug({
                title: “field data”,
                details: ‘SO: ’ + relatedSo + ' PO Location: ' + poLocation + ' SO Location: ' + soloc
            })