Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
search filters
I am completely new to this, but I have this search set up to retrun all order fulfilled yesterday and send shipment notifications. My search filters are as follows;
var filters = new Array(); filters[0] = new nlobjSearchFilter( 'custbodyfulfilled', null, 'equalTo', 1 ); filters[1] = new nlobjSearchFilter( 'Tracking Number', null, 'is not empty', null ); filters[2] = new nlobjSearchFilter( 'Actual Ship/Receipt Date', null, 'on', 'yesterday'); var searchresults = nlapiSearchRecord( 'salesorder', null, filters, null, new nlobjSearchColumn('terms') );But this gives me the error;
Code: SSS_INVALID_SRCH_FILTER
Details: An nlobjSearchFilter contains invalid search criteria: Tracking Number.
I understand this is probably because "Tracking Number" and "Actual Ship/Receipt Date" is not actually called that in the system so how would I construct this search. I am not sure how to find out what they are actually called in the system.
0