Discussions
nlapiSearchRecord on Customer : Internal ID
I need to perform a search for sales on using the Customer InternalID. I'm using the code below. It is returning null though I know it should return 2 records. I'm 90% the error is my first parameter of the seach filter. What I really need is to be able to reference the Customer : Internal ID not the salesorder InternalID. My problem boils down to, how do I refrence Customer : Internal ID in the Search filter?
var customerid = nlapiGetFieldValue('id') ;
var columns = new Array();
columns[0] = new nlobjSearchColumn('number')
var filters = new Array();
filters[0] = new nlobjSearchFilter('internalid', null, 'equalTo', customerid);
var searchresults = nlapiSearchRecord('salesorder', null, filters, columns);