Hello NetSuite Guru team,
I wrote a script as below but it threw the error "org.mozilla.javascript.EcmaError: TypeError: Cannot find function toLowerCase in object CASE WHEN {memberitem.locationquantityonhand} >0 THEN 'in stock' ELSE 'out of stock' END. (N/search/searchObject.js#1989)"
Could you please review the screenshots I attach below and let me know what is wrong with this?
/**
* @NApiVersion 2.x
*/
require(['N/search','N/file'], function(search,file) {
//kititem
var columns = [
search.createColumn({ name: 'internalid', label: 'SKU', summary: 'GROUP' }),
search.createColumn({
name: 'formulatext',
formula: [
"CASE WHEN {memberitem.locationquantityonhand} >0 THEN 'in stock' ELSE 'out of stock' END"
],
summary: 'MAX',
label: 'Status' }),
];
var filters = [
search.createFilter({
name: 'type',
operator: search.Operator.ANYOF,
values: ['Kit']
}),
search.createFilter({
name: 'isinactive',
operator: search.Operator.IS,
values: ['F']
}),
search.createFilter({
name: 'internalid',
operator: search.Operator.ANYOF,
values: ['9094']
}),
search.createFilter({
name: 'inventorylocation',
join: 'memberitem',
operator: search.Operator.ANYOF,
values: ['2']
})
];
var mySearch = search.create({
type: search.Type.KIT_ITEM,
columns: columns,
filters: filters
});
var resultCount = mySearch.runPaged({
}).count;
mySearch.run().each(function(result) {
var id = result.getValue({name: "internalid", summary: "GROUP"});
var status = result.getValue({
name: 'formulatext',summary:'MAX','formula':"CASE WHEN {memberitem.locationquantityonhand} >0 THEN 'in stock' ELSE 'out of stock' END"
});
return true;
});
});
I tried to load a existing saved search with the same filters and columns and the search can return the value as below:
Please help me check the issue.
Thank you very much.