Discussions
Sales Order Search Results
I am searching for all sales orders made by a customer. The results seem a little strange; however. I am 3 results for each sales order. Does anyone know why it's returning 3 results for each Sales Order and if there's a way to only get one returned?
Here's my search:
var soFilters = new Array();
soFilters[0] = new nlobjSearchFilter('entity', null, 'is', cusID);
var columns = new Array();
columns[0] = new nlobjSearchColumn('trandate');
columns[1] = new nlobjSearchColumn('status');
var searchresults = nlapiSearchRecord('salesorder', null, soFilters, columns);
for ( var i = 0;i < searchresults.length; i++ ){
nlapiLogExecution('DEBUG', 'loop: '+i);
var searchresult = searchresults[i];
}
When I log the searchresult ID, each sales order shows up 3 times.