Script para buscar Ordenes de Ventas en un estado específico

Se aplica a

Producto: NetSuite 2020.2

Escenario

Un usuario desea buscar órdenes de venta con estado Pendiente de facturación mediante SuiteScript.

Solución

SuiteScript 1.0:

var filters = new Array();

filters[0] = new nlobjSearchFilter('status', null, 'is', 'SalesOrd:F');

filters[1] = new nlobjSearchFilter('mainline', null, 'is', 'T');

var columns = new Array();

columns[0] = new nlobjSearchColumn('statusref');

var results = nlapiSearchRecord('salesorder', null,filters,columns);

SuiteScript 2.0:

var filters = new Array(); filters[0] = search.createFilter({   name: 'status',    operator: search.Operator.IS,     values: 'SalesOrd:F' }); filters[1] = search.createFilter({    name: 'mainline',  operator: search.Operator.IS,     values: true });  var columns = new Array(); columns[0] = search.createColumn({     name: 'statusref' });  var results = search.create({  type