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
Searching for item fulfillments
I have a saved search that looks for items fulfilled today. Its criteria are;
filters[0] = new nlobjSearchFilter( 'mainline', null, 'is', 'T' , null); filters[1] = new nlobjSearchFilter( 'actualshipdate', null, 'on', 'today', null); filters[2] = new nlobjSearchFilter( 'trackingnumbers', null, 'isnotempty', null , null);
The problem is this returns the entire sales order, and in the case of a partial fulfillment, where we may have shipped only a few lots from the order I don't want the entire sales order. Is there a way I can search for just the lots fulfilled today but at the same time pull them up as a group, if they are one, so that one email can be sent to a client for all the lots that are being shipped today rather than an individual email for ever lot sent? Thank You.
0