You have a hard coded date in the GROUP BY...that should be postdate instead...

>Well I'm sure it's something stupid but...
>
>This select will not run because it says the group by clause is missing or invalid. If someone would be so kind as to tell me what I'm missing I would really appreciate it.
>
>SELECT recordtype, importaccountid, DTOS({06/04/2003}) postdate, ;
> effectivedate, transactiontype, dbcr, ;
> SUM(IIF(dbcr = 'C', -1 * VAL(amount), VAL(amount))) amount, ;
> ref1, ref2, ref3, ref4, ref5, PADR(ALLTRIM(details),40) details, ;
> scvind, name, company, phone, SPACE(20) email, SPACE(15) fax, ;
> property, address1, address2, city, state, filler, zip, country, ;
> filler2 ;
> FROM cwtsdata ;
> GROUP BY recordtype, importaccountid, DTOS({06/04/2003}), effectivedate, ;
> transactiontype, dbcr, ref1, ref2, ref3, ref4, ref5, ;
> PADR(ALLTRIM(details),40), scvind, name, company, phone, SPACE(20), ;
> SPACE(15), property, address1, address2, city, state, filler, zip, ;
> country, filler2 ;
> INTO CURSOR CashwiseTerminalServicesData