当客户使用netsuite信用额度的75％时如何弹出窗口

Question

我对 Netsuite 或工作流程中的 javascript 非常陌生。我想在信用限额使用 75% 时弹出，然后当我们下销售订单时就会弹出。谁能帮我求公式吗？

Answer 1

下面是满足您的要求的示例客户端脚本，并附有关于每个步骤的作用的注释。如果您觉得有帮助，别忘了点赞哦。

更多信息可在 SuiteAnswer 中找到：客户端脚本、fieldChanged 函数， saveRecord 函数和N/记录模块。

/**
 * scriptName.js
 * @NApiVersion 2.0
 * @NScriptType ClientScript
 */

define(['N/currentRecord', 'N/record'], function(currentRecord, record){
    function fieldChanged(context){
        //after the Customer field value is selected
        if (context.fieldId === 'entity'){
            //get the current/SO record
            var soRec = context.currentRecord;
            //get customer id
            var customerId = soRec = record.getValue({fieldId: 'entity'});
            //get customer record
            var customerRec = record.load({type: record.Type.CUSTOMER, id: customerId});
            //get customer's credit limit and balance
            var creditLimit = customerRec.getValue({fieldId: 'creditlimit'});
            var customerBalance = customerRec.getValue({fieldId: 'balance'});
            //evaluate if 75% condition is met
            var testValue = Number(customerBalance)/Number(creditLimit);
            if(Number(testValue) >= .75){
                //if condition is met display message
                alert("Customer Balance/Credit Limit is >= 75%");
            }
        }
    }
    function saveRecord(context){
        //this function can be used to disallow saving of the new SO if credit limit is within 75%
        
        //get the current/SO record
        var soRec = context.currentRecord;
        //get customer id
        var customerId = soRec = record.getValue({fieldId: 'entity'});
        //get customer record
        var customerRec = record.load({type: record.Type.CUSTOMER, id: customerId});
        //get customer's credit limit and balance
        var creditLimit = customerRec.getValue({fieldId: 'creditlimit'});
        var customerBalance = customerRec.getValue({fieldId: 'balance'});
        //evaluate if 75% condition is met
        var testValue = Number(customerBalance)/Number(creditLimit);
        if(Number(testValue) >= .75){
            alert("You cannot save this record. Customer Balance/Credit Limit is >= 75%");
            return false; //do not allow save
        }
        else{
            return true; //allow save
        }
    }
    return {
        fieldChanged: fieldChanged,
        saveRecord: saveRecord
    }
});