AVRAGE INVENTORY

Former Member — Mon, 05 Apr 2021 00:03:36 GMT

I am trying to do a query to take out the stock with more than one date, I have tried this query but it does not work

SELECT T0.ItemCode,T0.ItemName,

DATE 1 = (select ItemCode, SUM(inqty)-SUM(outqty) from OINM where docdate <= '2021-04-01' group by ItemCode),

DATE 2 = (select ItemCode, SUM(inqty)-SUM(outqty) from OINM where docdate <= '2021-04-02' group by ItemCode),

DATE 3 = (select ItemCode, SUM(inqty)-SUM(outqty) from OINM where docdate <= '2021-04-03' group by ItemCode),

FROM OITM T0 INNER JOIN OINM T1 ON T0.ItemCode = T1.ItemCode group By T0.ItemCode, T0.ItemName

topic AVRAGE INVENTORY in Application Development and Automation Discussions