Post
Ask Question
Ramco Ramco

Ramco Ramco

  • 431
  • 3.5k
  • 564.7k

Group By Error

Jan 24 2025 5:49 AM

Hi

 I am getting error T1."CreatedBy" must be in a Group clause. How it can be used without adding in Group  By

SELECT T0."TransId",T1."TransType", T1."Account",Max(T2."AcctName"),Sum(T1."Debit"), Sum(T1."Credit"),
CASE 
WHEN T1."TransType" = '13' THEN (Select max(A0."LocCode") from INV1 A0 where A0."DocEntry" = T1."CreatedBy")

ELSE ' ****** '
END AS "Location"

Thanks


Answers (1)