Paul_s
02/24/2020, 12:33 PMvar filters = new Array();
filters[0] = new nlobjSearchFilter( 'type', null, 'anyof', 'ItemShip');
filters[1] = new nlobjSearchFilter("trandate", null, "notbefore", '24/2/2020');
//filters[1] = new nlobjSearchFilter('trandate', null, 'on', 'today');
filters[2] = new nlobjSearchFilter('type', 'createdfrom', 'anyof', "SalesOrd");
filters[3] = new nlobjSearchFilter('cogs', null, 'is', 'F');
filters[4] = new nlobjSearchFilter('status', null, 'anyof', 'ItemShip:C');
var columns = new Array();
columns[0] = new nlobjSearchColumn("internalid",null,null);
columns[1] = new nlobjSearchColumn("tranid",null,null);
columns[2] = new nlobjSearchColumn("statusref",null,null);
columns[3] = new nlobjSearchColumn("itemid","item",null);
columns[4] = new nlobjSearchColumn("type","item",null);
columns[5] = new nlobjSearchColumn("quantityuom",null,null);
columns[6] = new nlobjSearchColumn("unitabbreviation",null,null);
columns[7] = new nlobjSearchColumn("custitem_gc_uom_ppo","item",null);
columns[8] = new nlobjSearchColumn("createdfrom",null,null);
columns[9] = new nlobjSearchColumn("internalid", "item", null);
columns[10] = new nlobjSearchColumn("tranid", "createdfrom", null);
var result = nlapiSearchRecord('itemfulfillment', null, filters, columns);
search = result;