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

When I try to load search using SuiteScript, it returns me this error `Error - TypeError: rawColumns[i].push is not a function`
When I run that search in UI, it works.
Also it has many Formula, and summary type columns but not sure why this error is showing

just simple. <@UHP0BBX54>

```const searchID="aaa"
            let tmpSearch = search.load({
                id: searchID
            });```


<@UHP0BBX54>
Here is the saved search code when I try to export using chrome extension
```var invoiceSearchObj = search.create({
   type: "invoice",
   filters:
   [
      ["mainline","is","T"], 
      "AND", 
      ["status","anyof","CustInvc:A"], 
      "AND", 
      ["type","anyof","CustInvc"], 
      "AND", 
      ["duedate","after","today"]
   ],
   columns:
   [
      search.createColumn({
         name: "entity",
         summary: "GROUP",
         label: "Name"
      }),
      search.createColumn({
         name: "formulanumeric",
         summary: "SUM",
         formula: "CASE WHEN {duedate} - {today} &gt; 1 AND {duedate} - {today} &lt; 30 THEN {amount} ELSE 0 END",
         label: "1-30 Days"
      }),
      search.createColumn({
         name: "formulanumeric",
         summary: "SUM",
         formula: "CASE WHEN {duedate} - {today} &gt; 31 AND {duedate} - {today} &lt; 60 THEN {amount} ELSE 0 END",
         label: "31-60 Days"
      }),
      search.createColumn({
         name: "formulanumeric",
         summary: "SUM",
         formula: "CASE WHEN {duedate} - {today} &gt; 60 AND {duedate} - {today} &lt; 90 THEN {amount} ELSE 0 END",
         label: "61-90 Days"
      }),
      search.createColumn({
         name: "formulanumeric",
         summary: "SUM",
         formula: "CASE WHEN {duedate} - {today} &gt; 91 THEN {amount} ELSE 0 END",
         label: "Over 90 Days"
      }),
      search.createColumn({
         name: "formulanumeric",
         summary: "SUM",
         formula: "CASE WHEN {duedate} - {today} &gt; 0 AND {duedate} - {today} &lt;= 1 THEN {amount} ELSE 0 END",
         label: "Current"
      })
   ]
});```

do you get errors running that (create code)

search.create doesn't show error. but it shows an error when it runs

```            let searchRes = invoiceSearchObj.run().getRange(0, 1);
            log.debug('searchRes', JSON.stringify(searchRes));```

This error happens when we have Formula Numeric columns

not seeing anywhere in your posted script the code `rawColumns[i].push(…)` which is what the error is telling you is wrong

as a side note, read up about referencing result columns when you have multiple of the same formula field type (formulanumeric for example)
<https://stackoverflow.com/a/57596153>

I see you've been helped on the thread you created in <#C298P0BCK|> :+1:
<https://netsuiteprofessionals.slack.com/archives/C298P0BCK/p1680721259507319>