I have come across this error while saving some it...
# suitescripta
Ahmed
01/03/2020, 12:02 PMI have come across this error while saving some items.
b
battk
01/03/2020, 12:04 PMassuming you are actually trying to set an item on a sublist
battk
01/03/2020, 12:04 PMbut the error is saying that the item with internal id 5207 is an invalid choice for the field you are trying to set
a
Ahmed
01/03/2020, 12:05 PMyes trying to set an item on sublist
Ahmed
01/03/2020, 12:06 PMif(itemInteralId){
salesOrder.selectNewLine({
sublistId: 'item'
});
itemInteralIds[itemId] = itemInteralId;
salesOrder.setCurrentSublistValue({
sublistId: 'item',
fieldId: 'item',
value: itemInteralId
});
salesOrder.setCurrentSublistValue({
sublistId: 'item',
fieldId: 'quantity',
value: itemsData.item[itemData]["qty_ordered"]["#text"] //qty_ordered
});
salesOrder.commitLine({
sublistId: 'item'
});
} else {
ERROR_MESSAGES.push('Item doesnot exist in netsuite:'+ 'Magento product Id:'+itemsData.item[itemData].item_id["#text"]+' Magento product sku:'+itemsData.item[itemData]["sku"]["#text"]);
}
Ahmed
01/03/2020, 12:06 PMis there any issue
b
battk
01/03/2020, 12:07 PMis salesOrder from N/currentRecord or N/record
a
Ahmed
01/03/2020, 12:08 PMN/record
Ahmed
01/03/2020, 12:08 PMif(itemsData.item.length){
for (var itemData in itemsData.item) {
var itemId = itemsData.item[itemData].item_id["#text"];
var itemInteralId = searchInItem(itemsData.item[itemData]["sku"]["#text"]);
SUCCESS_MESSAGES.push('Item internal Id :'+ itemInteralId);
SUCCESS_MESSAGES.push('Quantity Ordered :'+itemsData.item[itemData]["qty_ordered"]["#text"]);
if(itemInteralId){
salesOrder.selectNewLine({
sublistId: 'item'
});
itemInteralIds[itemId] = itemInteralId;
salesOrder.setCurrentSublistValue({
sublistId: 'item',
fieldId: 'item',
value: itemInteralId
});
salesOrder.setCurrentSublistValue({
sublistId: 'item',
fieldId: 'quantity',
value: itemsData.item[itemData]["qty_ordered"]["#text"] //qty_ordered
});
salesOrder.commitLine({
sublistId: 'item'
});
} else {
ERROR_MESSAGES.push('Item doesnot exist in netsuite:'+ 'Magento product Id:'+itemsData.item[itemData].item_id["#text"]+' Magento product sku:'+itemsData.item[itemData]["sku"]["#text"]);
}
}
}
else{
var itemId = itemsData.item.item_id["#text"];
var itemInteralId = searchInItem(itemsData.item["sku"]["#text"]);
SUCCESS_MESSAGES.push('Item internal Id :'+ itemInteralId);
if(itemInteralId){
salesOrder.selectNewLine({
sublistId: 'item'
});
itemInteralIds[itemId] = itemInteralId;
salesOrder.setCurrentSublistValue({
sublistId: 'item',
fieldId: 'item',
value: itemInteralId
});
SUCCESS_MESSAGES.push('Qty Ordered :'+ itemsData.item["qty_ordered"]["#text"]);
salesOrder.setCurrentSublistValue({
sublistId: 'item',
fieldId: 'quantity',
value: itemsData.item["qty_ordered"]["#text"] //qty_ordered
});
salesOrder.commitLine({
sublistId: 'item'
});
} else {
ERROR_MESSAGES.push('Item doesnot exist in netsuite :' +'Magento product Id:'+itemsData.item.item_id["#text"]+' Magento product sku:'+itemsData.item["sku"]["#text"]);
}
}
}
catch(e){
ERROR_MESSAGES.push('Error in Saving Items: '+e);
}
/*
Ahmed
01/03/2020, 12:08 PMhere is the full code .. The Issue is in the loop
b
battk
01/03/2020, 12:08 PMcreate a sales order in the ui using the customer you are trying to use
a
Ahmed
01/03/2020, 12:09 PMOnly the code inside the for loop is throwing error
b
battk
01/03/2020, 12:09 PMtry to set the item you are trying to set in script on the sales order
battk
01/03/2020, 12:09 PMif its there, something weird is happening
battk
01/03/2020, 12:09 PMif its not, the item is not a valid choice for your customer
a
Ahmed
01/03/2020, 12:10 PMok i shall check
Ahmed
01/03/2020, 12:45 PMI could not add the item in any sales order . It wasnt showing in the items list
b
battk
01/03/2020, 12:46 PMas i said, not a valid selection
a
Ahmed
01/03/2020, 12:46 PMbut the item exists in netsuite
b
battk
01/03/2020, 12:46 PMthere are a bunch of things that make an item invalid for selection
battk
01/03/2020, 12:47 PMcommon ones are:
battk
01/03/2020, 12:47 PMinactive items
battk
01/03/2020, 12:47 PMclassification restrictions
battk
01/03/2020, 12:47 PMitem filter on transaction form
a
Ahmed
01/03/2020, 12:48 PMhow can i know that my item is inactive
Ahmed
01/03/2020, 12:49 PMwhere is that specified exactly
b
battk
01/03/2020, 12:50 PMits a field on the item record
a
Ahmed
01/03/2020, 12:52 PMIn the System Information tab ?
b
battk
01/03/2020, 12:52 PMon standard forms, yes
a
Ahmed
01/03/2020, 12:53 PMThank you very much sir ..
Ahmed
01/03/2020, 12:54 PMItem is inactive thats the issue .. You were right .. Thanks for help
4 Views