Discussions
Be sure you're subscribed to NetSuite communication to stay in the know about monthly happenings, updates and announcements. Subscribe
Returning Value from Existing Saved Search
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');