Hi
Invalid number on this code in below query
WHEN T1."TransType" = '1470000049' THEN (SELECT STRING_AGG(CAST(A11."ItemCode" AS NVARCHAR), ', ')
FROM OITM A11
WHERE A11."ItemCode" IN (
SELECT Distinct(A0."ItemCode") FROM ACQ1 A0 WHERE A0."DocEntry" = T1."CreatedBy" AND A0."ObjType" = '1470000049'
))
SELECT T0."TransId",T1."TransType",
CASE
WHEN T1."TransType" = '13' THEN (Select max(A0."LocCode") from INV1 A0 where A0."DocEntry" = T1."CreatedBy")
WHEN T1."TransType" = '1470000049' THEN (SELECT STRING_AGG(CAST(A11."ItemCode" AS NVARCHAR), ', ')
FROM OITM A11
WHERE A11."ItemCode" IN (
SELECT Distinct(A0."ItemCode") FROM ACQ1 A0 WHERE A0."DocEntry" = T1."CreatedBy" AND A0."ObjType" = '1470000049'
))
Else (Select Max("Location") from OWHS where "BPLid" = Max(T1."BPLId"))
END AS "Location"
FROM OJDT T0 INNER JOIN JDT1 T1 ON T0."TransId" = T1."TransId"
Left Join OACT T2 on T2."AcctCode" = T1."Account"
WHERE T1."TransType" = '1470000049'
group by T0."TransId",T1."TransType",T1."Account",T1."BPLId",T1."CreatedBy"
ORDER BY T1."TransType"
Thanks