I'm attempting to use an Item's "baseprice" field ...
# suitescript
m
I'm attempting to use an Item's "baseprice" field as a filter in a script search. I can pull the field in to a search as a result, but I get an error when I try to use it as a filter. I also couldn't get it to work in a summary formula. ie. using {baseprice}. Has anyone had any luck with this field? Example of my search:
Copy code
var itemSearchObj = _search.create({
   type: "item",
   filters: [
      ["isinactive","is","F"], 
      "AND", 
      ["costestimate","greaterthan","0"],
      "AND", 
      ["custitem_sellable_item","is","T"], 
      "AND", 
      ["custitem_calculated_margin","isempty",""],
      "AND", 
      ["baseprice","greaterthan","0.00"] // Is not working
   ],
   columns: [
      "internalid",
      "displayname",
      "baseprice",
      "costestimate",
      "type",
      "custitem_calculated_margin"
   ]
});