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');
nlapiLogExecution('DEBUG', 'details','depositAmountValue='+depositAmountValue);
//var results = depositAmount[0];
//var columns = results.getAllColumns();
//nlapiLogExecution('DEBUG', 'details','columns='+columns);
//nlapiLogExecution('DEBUG', 'details','columnText='+results.getValue(columns[1]));
//getAllColumns() is a method within the nlobjSearchResult Class
// getAllColumns() - Returns an array of nlobjSearchColumn objects containing all the columns returned in a specified search
var salesOrderRecord = nlapiLoadRecord('salesorder', salesOrder);
var amount = salesOrderRecord.getFieldValue('total');
nlapiLogExecution('DEBUG', 'details', amount);
if (depositAmount < amount) {
return false;
} else {
return true;
}
}
}
Saved Search:
Sum of Amount
10000.00