Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Adding search.Filter with a formula in it to a search.create
I cant seem to figure out why my search.created will not accept my filter. It errors saying its not an array. Yet when I look at it on the debugger the fields are exactly right. I've tried creating the filter in the set of arrays, passing the filter as a variable multiple ways. Has anyone figured this out? Here is my code as an example.
var closingMonthSearch = search.create({ type: record.Type.SALES_ORDER, columns: ['department', 'type', 'datecreated', 'item', 'tranid', 'entity', 'quantity', 'shiprecvstatusline', 'quantitybilled', 'quantityshiprecv', 'effectiverate', 'rate', 'isclosed', 'line', search.createColumn({ name: 'formulanumeric', type: 'float', formula: '{quantity}-{quantityshiprecv}', sortdir: 'ASC' }), search.createColumn({ name: 'formulanumeric', type: 'float', formula: '({quantity}-{quantityshiprecv})*{effectiverate}', sortdir: 'ASC' }), search.createColumn({ name: 'formulanumeric', type: 'float', formula: 'case when {effectiverate} = 0 then ({quantity}-{quantityshiprecv})*{rate} else 0 end', sortdir: 'ASC' }), 'custbody16'], filters: [ ['type', 'anyof', 'SalesOrd'], 'and', ['account', 'anyof', '54'], 'and', ['datecreated', 'after', 'monthsago20'], 'and', ['closed', 'is', 'F'], 'and', search.createFilter({ //THIS IS THE LINE THAT IM HAVING PROBLEMS name: 'formulanumeric', operator: 'greaterthan', values: '0', formula: '{quantity}-{quantityshiprecv}' }) ] }); 0