Batch Wise Bin Location

ramco1917 — Wed, 12 Feb 2025 09:43:26 GMT

I have below query i want Bin location also

SELECT

T1."WhsCode",

T1."ItemCode",

T1."BatchNum" As "Batch No.",

SUM(CASE WHEN T1."Direction" = 0 THEN T1."Quantity" ELSE 0 END) -

SUM(CASE WHEN T1."Direction" = 1 THEN T1."Quantity" ELSE 0 END) AS "Quantity"

FROM IBT1 T1

LEFT JOIN OITM T2 ON T2."ItemCode" = T1."ItemCode"

GROUP BY T1."WhsCode", T1."ItemCode", T1."BatchNum"

Thanks

Re: Batch Wise Bin Location

SonTran — Mon, 17 Feb 2025 08:40:21 GMT

Hi,

You can have a look at below link

Hope this helps,

SonTran