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