Hi,
This is my first real script and I'm getting this error. I ran it through the console and had no problems with it, however it tosses this error when I upload it and try to create a sales order.
The error occurs in line 4 of this code on the demand[j].rawValues[0].value .
function makeComparisons(itemList, itemQuantity, demand, supply){ for ( var i = 0; itemList != null && i < itemList.length; i++){ for (var j = 0; demand != null && j < demand.length; j++){ if (itemList[i] == demand[j].rawValues[0].value){ if( parseInt(itemQuantity[i]) <= parseInt(demand[j].rawValues[2].value) && demand[j].rawValues[2].value != ""){ var today = nlapiGetFieldValue('trandate'); var dateToSet = stringtodate(modifyDateByDays(today,3)); nlapiSelectLineItem('item',parseInt(j)+1); nlapiSetCurrentLineItemValue('item','custcol_expect_ship_date_so_line',dateToSet.dateFormat('m/d/y')); } else { if(demand[j].rawValues[2].value > 0){ itemQuantity[i] = (parseInt(itemQuantity[i]) - parseInt(demand[j].rawValues[2].value)); } } } } }The entire code looks like this:function beforeSubmit(type){ if(type == 'create' || type == 'edit'){ setExpShip(); } function setExpShip(){ var iL = getListOfItems(); var iQ = getQtyOfItems(); var d = getDemand(iL); var s = getSupply(iL); makeComparisons(iL,iQ,d,s); } function getListOfItems() { var itemList = []; for ( var i = 1; i <= nlapiGetLineItemCount('item'); i++) { itemList.push(nlapiGetLineItemValue('item', 'item', i)); } return itemList; } function getQtyOfItems() { var itemQuantity = []; for ( var i = 1; i <= nlapiGetLineItemCount('item');i++){ itemQuantity.push(nlapiGetLineItemValue('item','quantity',i)); } return itemQuantity; } function getDemand(itemList) { var demandFilters = []; demandFilters.push( new nlobjSearchFilter('item', null, 'anyof', itemList)); var demand = nlapiSearchRecord('transaction',1112,demandFilters); return demand; } function getSupply(itemList) { var supplyFilters = []; supplyFilters.push( new nlobjSearchFilter('item',null,'anyof',itemList)); var supply = nlapiSearchRecord('transaction',1114,supplyFilters); return supply; } function makeComparisons(itemList, itemQuantity, demand, supply){ for ( var i = 0; itemList != null && i < itemList.length; i++){ for (var j = 0; demand != null && j < demand.length; j++){ if (itemList[i] == demand[j].rawValues[0].value){ if( parseInt(itemQuantity[i]) <= parseInt(demand[j].rawValues[2].value) && demand[j].rawValues[2].value != ""){ var today = nlapiGetFieldValue('trandate'); var dateToSet = stringtodate(modifyDateByDays(today,3)); nlapiSelectLineItem('item',parseInt(j)+1); nlapiSetCurrentLineItemValue('item','custcol_expect_ship_date_so_line',dateToSet.dateFormat('m/d/y')); } else { if(demand[j].rawValues[2].value > 0){ itemQuantity[i] = (parseInt(itemQuantity[i]) - parseInt(demand[j].rawValues[2].value)); } } } } } for (var k = 0; itemList != null && k < itemList.length; k++){ for (var m = 0; supply != null && m < supply.length; m++){ if( itemList[k] == supply[m].rawValues[1].value){ if ( supply[m].rawValues[4].value != ""){ var emptyDate = nlapiGetLineItemValue('item','custcol_expect_ship_date_so_line',parseInt(k)+1); if (emptyDate == ""){ if( (parseInt(itemQuantity[k]) + parseInt(supply[m].rawValues[4].value) <= parseInt(supply[m].rawValues[2].value))){ var expShipDate = nlapiStringToDate(supply[m].rawValues[3].value); if (expShipDate != "" && expShipDate != null){ nlapiSelectLineItem('item',parseInt(k)+1); nlapiSetCurrentLineItemValue('item','custcol_expect_ship_date_so_line',expShipDate.dateFormat('m/d/y')); } else { nlapiSelectLineItem('item',parseInt(k)+1); nlapiSetCurrentLineItemValue('item','custcol_expect_ship_date_so_line','01/01/1900'); } } else { itemQuantity[k] = parseInt(itemQuantity[k]) - parseInt(supply[m].rawValues[2].value); supply[m].rawValues[4].value = Math.max(0,parseInt(supply[m].rawValues[4].value) - parseInt(supply[m].rawValues[4].value)); } } } else { var emptyDate = nlapiGetLineItemValue('item','custcol_expect_ship_date_so_line',parseInt(k)+1); if (emptyDate == ""){ supply[m].rawValues[4].value = 0; if( (parseInt(itemQuantity[k]) + parseInt(supply[m].rawValues[4].value) <= parseInt(supply[m].rawValues[2].value))){ var expShipDate = nlapiStringToDate(supply[m].rawValues[3].value); if (expShipDate != "" && expShipDate != null){ nlapiSelectLineItem('item',parseInt(k)+1); nlapiSetCurrentLineItemValue('item','custcol_expect_ship_date_so_line',expShipDate.dateFormat('m/d/y'),(parseInt(k)+1)); } else { nlapiSelectLineItem('item',parseInt(k)+1); nlapiSetCurrentLineItemValue('item','custcol_expect_ship_date_so_line','01/01/1900'); } } else { itemQuantity[k] = parseInt(itemQuantity[k]) - parseInt(supply[m].rawValues[2].value); supply[m].rawValues[4].value = Math.max(0,parseInt(supply[m].rawValues[4].value) - parseInt(supply[m].rawValues[4].value)); } } } } } } } function modifyDateByDays(date, days) { if (!date.getDate) { date = nlapiStringToDate(date); } var newDate = new Date(date); newDate.setDate(newDate.getDate() + parseInt(days)); var dateString = nlapiDateToString(newDate); return dateString; } } Any help would be appreciated. I'm hoping this is just some rookie mistake that I'm making.