NetSuite脚本问题：查询结果正常但无法赋值到目标字段

问题场景 #

创建了Saved Search，日志调试显示结果符合预期，但尝试将值设置到目标字段时无任何响应，且无错误提示。相关脚本代码如下：

if(cust){
    var custSave = search.create({
        type: "customrecord_me_customer_sales_person",
        filters: [
            ["custrecord_me_customer_name","is",cust],
        ],
        columns: [
            search.createColumn({name: "custrecord_me_customer_name", label: "ME - Customer Name"}),
            search.createColumn({
                name: "custrecord_me_join_sales_person",
                sort: search.Sort.ASC,
                label: "ME - Join Customer Sales Person"
            })
        ]
    });
    log.debug(
        "sales person"+JSON.stringify(custSave)
    );
    var custSR = custSave.run().getRange(0, 1000);
    var cust = custSR[0].getText("custrecord_me_join_sales_person");//the result I want in
    log.debug(
        "join customer sales person"+JSON.stringify(cust)
    );
    return true;

    if (cust.hasOwnProperty('custrecord_me_join_sales_person')){
        var salesPerson = cust.getValue('custrecord_me_join_sales_person')[0].value;
        //var salesPerson = currentRecord.getValue({"custrecord_me_field_deposit_salesman"});

        currentRecord.setValue({ fieldId: 'custbody_me_field_deposit_salesman', value: salesPerson });
    }
    else{
        currentRecord.setValue({ fieldId: 'custbody_me_field_deposit_salesman', value: null });
    }

}              
}           
}

return {
    fieldChanged: fieldChanged
}

存在的错误点 #

• 提前return终止执行：在打印完目标值的日志后，直接执行了return true;，这会直接跳出当前函数，后续的字段赋值逻辑完全不会被执行，这是字段无响应的核心原因。
• 变量覆盖导致逻辑失效：原本的cust是传入的客户参数，但后续用var cust = custSR[0].getText(...)将其重新赋值为字符串类型的销售人文本，导致后面的cust.hasOwnProperty('custrecord_me_join_sales_person')判断永远为false（字符串对象不存在该属性）。
• 取值方法错误：就算执行到赋值逻辑，cust.getValue(...)也是错误的——此时cust已经是字符串，不是搜索结果对象；正确的取值应该从custSR[0]这个搜索结果记录上调用getValue或getText。

修正后的代码示例 #

if(cust){
    var custSave = search.create({
        type: "customrecord_me_customer_sales_person",
        filters: [
            ["custrecord_me_customer_name","is",cust],
        ],
        columns: [
            search.createColumn({name: "custrecord_me_customer_name", label: "ME - Customer Name"}),
            search.createColumn({
                name: "custrecord_me_join_sales_person",
                sort: search.Sort.ASC,
                label: "ME - Join Customer Sales Person"
            })
        ]
    });
    log.debug("sales person", JSON.stringify(custSave));
    var custSR = custSave.run().getRange(0, 1000);
    
    // 避免覆盖原cust变量，改用新变量名
    var salesPersonText = custSR[0].getText("custrecord_me_join_sales_person");
    log.debug("join customer sales person", JSON.stringify(salesPersonText));

    // 检查搜索结果是否存在目标字段值
    if (custSR.length > 0) {
        // 获取字段的实际值（而非文本），用于赋值
        var salesPersonValue = custSR[0].getValue("custrecord_me_join_sales_person");
        currentRecord.setValue({ 
            fieldId: 'custbody_me_field_deposit_salesman', 
            value: salesPersonValue 
        });
    } else {
        currentRecord.setValue({ 
            fieldId: 'custbody_me_field_deposit_salesman', 
            value: null 
        });
    }
}              

return {
    fieldChanged: fieldChanged
}

内容的提问来源于stack exchange，提问作者antechf11