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.
Keep an eye out for upcoming NetSuite events, including meetups, workshops, and webinars. These sessions are a great way to connect with peers, learn from experts, and stay current on the latest NetSuite updates and best practices. Registration links are provided in each event.
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