This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Has anyone been successful in using "otherprices" in a search?  I am able to use it a saved search but can not seem to get it to work in a suitescript search

I am newer to NS, is this a different base price or custom price? If not would like the education.

I was finding documentation that said you could search "otherprices" field and that would provide you all of the price levels, however, this doesn't work in suitescript

you resolved? how did you get "price1", "price2", "price3"? through what object or manner? just learning

just using them as field names in a search

```      var items_search = _search.create({
        type: "inventoryitem",
        columns: [
          "internalid",
          "baseprice",
          "price5",  //Default
          "price29", //List
          "price30", //MAP
          "price31", //Amazon
          "price28", //8%
          "price27", //9%
          "price26", //10%
          "price25", //12%
          "price24", //14%
          "price23", //15%
          "price22", //18%
          "price6",  //20%
          "price21", //22%
          "price20", //25%
          "price19", //30%
          "price18", //35%
          "price17", //40%
          "price16", //45%
          "price15", //50%
          "price14", //55%
          "price13", //60%
          "price12", //65%
          "price11", //70%
          "price10", //75%
          "price9",  //80%
          "price8",  //85%
          "price7",  //90%
        ],
        filters: [
          ["custitem_mro_pricematrixgroup","is", pmg_id]
        ]
      });```