Discussions
The exception throw in the suitescript 2.0 for creating a saved search of kit package.
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',