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 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