Batch Wise Bin Location

[ramco1917]

Hi

  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

[SonTran]

Hi,

You can have a look at below link

https://forum.sapb1.vn/community/inventory/cau-truy-van-query-thong-tin-hang-ton-kho-voi-batch-va-bi...

Hope this helps,

SonTran