Hello everyone, first of all thank you for taking your time to read this.

I am working on a complex suiteql query. I ran into some errors so I started eliminating complexity and came around this very simple query

select top 1000

t.tranId as doc_id,

t.trandate as date,

SUM (tl.quantity) as total_quantity

from

transaction t

join

transactionline tl on tl.transaction = t.id

where

t.type = 'CustInvc'

AND tl.mainline = 'F'

AND tl.taxline = 'F'

AND t.trandate >= TO_DATE('2024-01-01', 'YYYY-MM-DD')

AND t.trandate <= TO_DATE('2024-12-31', 'YYYY-MM-DD')

I am using this query in SuiteQuery Tool by Tim Dietrich.
Why I am getting the “Search error occurred: Invalid or unsupported search” when using the sum syntax in the query?
Also, the group by returns the same thing.
I saw in some of his tutorials so I know atleast group by should work. Any leads into where should I look?