Trying to get the Quantity Available value for a Kit Item when order is place via the website. Currently I get a NaN value, where the script works if order is created via the back end.
My question is... why can you get the Quantity Available value for Kit Items when the order is created via the backend but not when the order is created via the store? Is there a workaround I should be using?
function processWebOrders(){
try {
if (type == 'create') {
var newId = nlapiGetRecordId();
var newType = nlapiGetRecordType();
var soRec = nlapiLoadRecord(newType, newId);
var orderNum = soRec.getFieldValue('tranid'); // get Sales Order #
nlapiLogExecution('DEBUG', 'Sales Order#:', orderNum);
//GET every item ids
var itemIds = [];
for (var i = 1; i <= nlapiGetLineItemCount('item'); i++) {
itemIds[i] = nlapiGetLineItemValue('item', 'item', i);
}
var item_quantity_available = [];
var item_weight = [];
var item_type = [];
var columns = [];
columns[0] = new nlobjSearchColumn('internalid'); //Item Id
columns[1] = new nlobjSearchColumn('quantityavailable') // get quantity avalable
columns[2] = new nlobjSearchColumn('type') //get item type value
var filters = [];
filters[0] = new nlobjSearchFilter('internalid', null, 'anyof', itemIds);
var search = nlapiSearchRecord('item', null, filters, columns);
if (search != null) {
for (var i = 0; i < search.length; i++) {
item_quantity_available[search[i].getValue('internalid')] = search[i].getValue('quantityavailable'); // get quantity available
item_weight[search[i].getValue('internalid')] = search[i].getValue('weight'); //get item Weight
item_type[search[i].getValue('internalid')] = search[i].getValue('type'); // get item type value
}
}
// ****** LOOP THROUGH ALL LINE ITEMS *******
for (var i = 1; i <= nlapiGetLineItemCount('item'); i++) {
var item = nlapiGetLineItemValue('item', 'item', i);
nlapiLogExecution('DEBUG', 'Item:', item);
var quantityOrder = parseFloat(nlapiGetLineItemValue('item', 'quantity', i));
nlapiLogExecution('DEBUG', 'Qty Ordered:', quantityOrder);
var itemType = item_type[item];
nlapiLogExecution('DEBUG', 'Item Type:', itemType);
if (itemType != 'Kit') {
var quantityAvailable = item_quantity_available[item];
nlapiLogExecution('DEBUG', 'Qty Available:', quantityAvailable);
}
else {
var quantityAvailableKitItem = parseInt(nlapiGetLineItemValue('item', 'quantityavailable', i));
nlapiLogExecution('DEBUG', 'Kit Item Qty Available:', quantityAvailableKitItem);
}
}
nlapiSubmitRecord(soRec, true, false);
var context = nlapiGetContext();
var usageRemaining = context.getRemainingUsage();
nlapiLogExecution('Debug', 'Script Unit Usage:', usageRemaining); // log script unit usage
}
}
catch (err) {
if (err instanceof nlobjError) {
nlapiLogExecution('Debug', 'Error Details', 'Error: ' + err.getDetails());
}
else {
nlapiLogExecution('Debug', 'Error Details', 'Error: ' + err.message);
}
}
}