function SCH_RemoveItem_SO()
{
var customrec =...
# suitescriptm
miachel douglas
09/23/2018, 8:46 PMfunction SCH_RemoveItem_SO()
{
var customrec = nlapiLoadRecord('customrecordremove_or_replace_item_from',1);
nlapiLogExecution('DEBUG','MedicAlert_SCH_RemoveItem_SO','customrec ='+customrec);
var itemtoremove = customrec.getFieldValue('custrecord_item_to_remove');
nlapiLogExecution('DEBUG','MedicAlert_SCH_RemoveItem_SO','itemtoremove ='+itemtoremove);
var itemtoreplace = customrec.getFieldValue('custrecord_item_to_replace');
nlapiLogExecution('DEBUG','MedicAlert_SCH_RemoveItem_SO','itemtoreplace ='+itemtoreplace);
var salesorderSearch = nlapiSearchRecord("salesorder",null,
[
["type","anyof","SalesOrd"],
"AND",
["status","anyof","SalesOrd:A","SalesOrd:D","SalesOrd:E","SalesOrd:B"],
"AND",
["applyingtransaction.type","noneof","WorkOrd","ItemShip"],
"AND",
["item.internalid","anyof",itemtoremove],
"AND",
["mainline","is","F"]
],
[
new nlobjSearchColumn("internalid"),
new nlobjSearchColumn("tranid"),
new nlobjSearchColumn("line"),
new nlobjSearchColumn("linesequencenumber"),
new nlobjSearchColumn("item"),
new nlobjSearchColumn("quantity"),
new nlobjSearchColumn("quantitypacked"),
new nlobjSearchColumn("quantityshiprecv"),
new nlobjSearchColumn("quantitypicked"),
new nlobjSearchColumn("applyingtransaction")
]
);
if(_logValidation(salesorderSearch))
{
for (var i = 0; i < salesorderSearch.length; i++)
{
var itemID = salesorderSearch[i].getValue('item');
nlapiLogExecution('DEBUG','MedicAlert_SCH_RemoveItem_SO','itemID ='+itemID);
var quantity = salesorderSearch[i].getValue('quantity');
nlapiLogExecution('DEBUG','MedicAlert_SCH_RemoveItem_SO','quantity ='+quantity);
var soid = salesorderSearch[i].getValue('internalid');
nlapiLogExecution('DEBUG','MedicAlert_SCH_RemoveItem_SO','soid ='+soid);
var lineid = salesorderSearch[i].getValue('line');
nlapiLogExecution('DEBUG','MedicAlert_SCH_RemoveItem_SO','lineid ='+lineid);
var lineseqnumber = salesorderSearch[i].getValue('linesequencenumber');
nlapiLogExecution('DEBUG','MedicAlert_SCH_RemoveItem_SO','linesequencenumber-'+lineseqnumber);
var soobj = nlapiLoadRecord('salesorder',soid);
nlapiLogExecution('DEBUG','MedicAlert_SCH_RemoveItem_SO','soobj ='+soobj);
soobj.removeLineItem('item',lineseqnumber); // Remove assembly Item
nlapiLogExecution('DEBUG','MedicAlert_SCH_RemoveItem_SO','entered');
/*if(_logValidation(itemtoreplace))
{
soobj.selectNewLineItem('item');
soobj.setCurrentLineItemValue('item', 'item', itemtoreplace); //Setting the Same Item again
soobj.setCurrentLineItemValue('item', 'quantity', quantity);
soobj.commitLineItem('item');
}*/
var id =nlapiSubmitRecord(soobj);
nlapiLogExecution('DEBUG','MedicAlert_SCH_RemoveItem_SO','id ='+id );
} //End of For loop
}
}
function _logValidation(value)
{
if(value!='null' && value != '' && value != undefined && value != 'undefined' && value != 'NaN' && value != NaN)
{
return true;
}
else
{
return false;
}
}
2 Views