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.
Searching for item fulfillments
I want to make search that returns item fulfillments but I am not sure how to use the criteria;
Date on today
type is item fulfillment
Mainline is True
I have this scripted as the following;
var filters = new Array(); filters[0] = new nlobjSearchFilter( 'mainline', null, 'is', 'T' , null); filters[1] = new nlobjSearchFilter( 'date', null, 'on', 'today', null); filters[2] = new nlobjSearchFilter( 'type', null, 'is', 'itemfulfillment' , null); var columns = new Array(); columns[0] = new nlobjSearchColumn( 'entity' ); var searchresults = nlapiSearchRecord( 'itemfulfillment', null, filters, columns);
But this throws me an error;
Code: SSS_INVALID_SRCH_FILTER Details: An nlobjSearchFilter contains invalid search criteria: date.
Even though Date is what I would use if I made this a saved search. Any help would be appreciated. Thank You.
0