Hi everyone,

We have an old but established function running in our account that creates deposit records against sales orders. It has been running for a long time. and only in the last week has it started to fail by not applying the submitted amount to the deposit record.

The payment amount is always changing to the total in the sales order and not to the payment value that we submit. The below JSON is a dump of the record as we create it and logged to the suitescript logger in Netsuite.

everything saves in Netsuite, but the amount is never what we submit, its always the total of the sales order

PHP Code:

{“tranid”:”11″,”exchangerate”:1,”trandate”:”01/11/2016″,”currencyname”:”USA”,”salesorder”:{“internalid”:”1083″,”name”:”Sales Order #246″},”undepfunds”:true,”isrecurringpayment”:false,”ccapproved”:false,”postingperiod”:{“internalid”:”3″,”name”:”Jan 2002″},”recordtype”:”customerdeposit”,”currency”:{“internalid”:”1″,”name”:”USA”},”payment”:99.25,”id”:”1094″,”customer”:{“internalid”:”-5″,”name”:”John Smith”}} 

Below is the function we used / have used for over a year

PHP Code:

/* this function records a deposit payment */
function createDeposit(objData)
{
    try
    {    
        var depositData = objData.data[0];
        var recDeposit                                 = nlapiCreateRecord(‘customerdeposit’);
        recDeposit.setFieldValue(‘account’,         setValue(depositData.account));
        recDeposit.setFieldValue(‘payment’,         setValue(depositData.payment));
        recDeposit.setFieldValue(‘salesorder’,      setValue(depositData.salesorder));
        recDeposit.setFieldValue(‘trandate’,        setValue(depositData.trandate));
        recDeposit.setFieldValue(‘customer’,        setValue(depositData.customer));
        recDeposit.setFieldValue(‘paymentMethod’,   setValue(depositData.paymentMethod));

        depositID = nlapiSubmitRecord(recDeposit, true, true);
        objResponseData.internal_id             = depositID;
    }
    catch (e)
    {
        var stErrMsg = ”;
        if (e.getDetails != undefined)
        {
            stErrMsg = e.getCode() + ‘ ‘ + e.getDetails() + ‘ ‘ + e.getStackTrace();
        }
        else
        {
            stErrMsg = e.toString();
        }
    }
}
// end function 

This is currently deployed in my netsuite sandbox / developer testrdrive account and no matter what we do, it continually overrides the amount with the sales order amount.

We can apply any values we want via the UI, but cannot apply it via suitescript.

Any help greatly appreciated
This is a cached copy. Click here to see the original post.