I'm trying to execute a simple group by and am getting 'invalid or unsupported search'. I'm very new to suiteql. Otherwise the search returns what I need.

group by SUM????

That's my aggregate function. I'm very new.

aggregate function goes in select simplified select tranid, sum(amount) group by tranid

This also gives me an error. Can I have extra columns in the SELECT statement (for debugging purposes) or do I need to remove them.

all non-aggregate columns in select MUST be in GROUP BY list...

Ah thank you very much.

also, maybe it works, but I suggest you change line #2 "as item" into 'as somethingelse" to avoiding confusion with item in join statement

@Alan Fitch Not sure if this is what you're looking for, but it might help: https://timdietrich.me/blog/netsuite-suiteql-journal-entries-gl-impact/