Hello Everyone,

Does anyone have idea on retriving the value from existing saved search using the suite script?
The Issue is the result on saved search is summed one(total Amount--summary type=sum) and I am using below code to retrive but I am not succesful.Please help!

Code:
function CheckCustomerDeposit(depositSearchResults, salesOrder) {
    nlapiLogExecution('DEBUG', 'details', 'inside function');
    var filters = new Array();
    filters[0] = new nlobjSearchFilter('salesorder', null, 'is', salesOrder);
    //columns[0]=new nlobjSearchColumn('payment');
    // search record using following filters

    var depositAmount = nlapiSearchRecord('customerdeposit',depositSearchResults, filters, null);


    if (depositAmount && depositAmount.length == 1) {
        nlapiLogExecution('DEBUG', 'details','depositAmount.length='+depositAmount.length);
    var depositAmountValue = depositAmount.getValue('amount',null,'sum');