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

In the Excel query editor:

select MAX(date) from systemnote where recordid = '102' and field ='INVTITEM.RUNITPRICE'
This works (Brings back only the date column)

select MAX(date), field from systemnote where recordid = '102' and field ='INVTITEM.RUNITPRICE'
This does not. (I want more columns brought back)

This is the error I receive:
DataSource.Error: ODBC: ERROR [42000] [NetSuite][ODBC 64bit driver][OpenAccess SDK SQL Engine]Invalid SQL Syntax. All columns of the select list &amp; order by should have set functions.[10136]
Details:
    DataSourceKind=Odbc
    DataSourcePath=dsn=NetSuite
    OdbcErrors=[Table]

I think the issue here is that if you use a function on any column, you must use a function or group by the remaining columns.

```select MAX(date), field from systemnote where recordid = '102' and field ='INVTITEM.RUNITPRICE' group by field```

<@UH8L0UJAU> Ah.. perfect... I was putting my group by in the wrong spot when I was trying that. I tested want you suggested and I'm back in business. Thank you