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.
Extract Lot and Expiration Dates
I have attempted to create a script that will fill in the lot number boxes on the fulfillment page. Or at least suggest which lot numbers they should be using. Right now I am at the point in this script of just pulling information from a saved search I have created. The issue is, I cannot seem to pull the data correctly as I keep getting null values. Can anyone give me a fresh look at this code and see where my errors might be?
function pageInit(type, name) { //first get list of itmes //then on each item search for what lost numbers and qty are avail //populate that field var lineNum = nlapiGetLineItemCount('item'); var counterOfLines = 1; while (counterOfLines <= lineNum) { var lineItem = nlapiGetLineItemValue('item','item',counterOfLines); var lineQty = nlapiGetLineItemValue('item','quantity',counterOfLines); //alert('The line item for this record is: ' + lineItem + ' on line ' + counterOfLines + ' with qty ' + lineQty); //now run a search for each line to grab a lot number var filters = new Array(); filters[0] = new nlobjSearchFilter('internalId', null, 'is', lineItem); //alert("Setting search results to " 0