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.
How to filter item fulfillment
Hi,
I am trying to filter Item fulfillment from sales order with following condition in suite script.
var id='DO-000611'; var localsearchFilters = new Array(); localsearchFilters[0] = new nlobjSearchFilter('internalid', null, 'is', soNo); localsearchFilters[1] = new nlobjSearchFilter('mainline', null, 'is', 'F'); localsearchFilters[2] = new nlobjSearchFilter('type', null, 'is', 'SalesOrd'); localsearchFilters[3] = new nlobjSearchFilter('formulanumeric', null, 'equalto', 1); localsearchFilters[3].setFormula('CASE WHEN {applyingtransaction} ='Item Fulfillment #'+id+'' THEN 1 WHEN ({applyingtransaction} =' ' OR {applyingtransaction} IS NULL) THEN 1 ELSE 0 END'); var localsearchRslt = nlapiSearchRecord('salesorder', null, localsearchFilters, lolcalsearchColumns);But it bring all item than only that applyingtransaction is equal to id or empty.
Please help.
Thank you
0