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.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
Stay in the Know
Be sure you're subscribed to NetSuite communication to stay in the know about monthly happenings, updates and announcements. Subscribe
Be sure you're subscribed to NetSuite communication to stay in the know about monthly happenings, updates and announcements. Subscribe
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