I am trying to use from code on a prior project to set a date last ordered on item records. It runs on POs and looks at each item to reset the Last Ordered Date (a custom field).
I am struggling to get it to recognize when I have a serial number that it uses serializedinventoryitem instead of inventoryitem. I feel like I am probably missing something missing obvious. Here is the code:
function updateLastReceivedDate()
{
var item;
var lastPurchaseDate ;
var trandate="";
var itemType;
var item_rec_type ="";
var itemCount = nlapiGetLineItemCount("item");
var purchaseMonth;
var purchaseYear;
var purchaseDay;
for(var i = 1; i<= itemCount; i++){
trandate="";
item = nlapiGetLineItemValue("item", "item", i );
itemType = nlapiGetLineItemText('item', 'itemtype', i);
//SEARCH FOR THE LAST BILL AND GET THE BILL DATE
var filters = new Array();
filters[0] = new nlobjSearchFilter('item', null, 'is', item);
var columns = new Array();
columns[0] = new nlobjSearchColumn('trandate');
var billSearchArr = nlapiSearchRecord('transaction', 'customsearch1345', filters, columns);
if(billSearchArr==null){
continue;
}
if(billSearchArr!=null)
trandate = new Date(billSearchArr[0].getValue("trandate"));
if(trandate == "")
continue;
purchaseDay = ""+(trandate.getDate());
if(purchaseDay.length==1) purchaseDay = "0"+purchaseDay;
purchaseMonth = ""+(trandate.getMonth()+1);
if(purchaseMonth.length==1) purchaseMonth = "0"+purchaseMonth;
purchaseYear = ""+trandate.getFullYear();
lastPurchaseDate = purchaseMonth+"/"+purchaseDay+"/"+purchaseYear;
if( itemType == "NonInvtPart") item_rec_type = "noninventoryitem";
if( itemType == "Assembly") item_rec_type = "assemblyitem";
if((itemType == "InvtPart") && ((nlapiLoadRecord('serializedinventoryitem', item) !== null) || (nlapiLoadRecord('serializedinventoryitem', item) !== ""))){
item_rec_type = "serializedinventoryitem";// Serialized Inventory Item
}
if((itemType == "InvtPart") && ((nlapiLoadRecord('inventoryitem', item) !== "") || (null !== nlapiLoadRecord('inventoryitem', item)))){
item_rec_type = "inventoryitem";// Inventory Item
}
nlapiSubmitField(item_rec_type, item, 'custitem_dlc', lastPurchaseDate);
}
return true;
}
I am getting the error "The record type [] is invalid." when I order a serialized inventory item.