Skip to Content
1

Batchwise inventory report for selected date

Jan 18, 2017 at 11:09 AM

309

avatar image
Former Member

Dear Experts,

I am trying to pull report with help of sql query which show batch wise stock report upto selected date. Right now i have following query which is showing batch wise current stock. Here is the query :

SELECT T0.ItemCode, T1.INDATE, (T0.Quantity-T0.CommitQty) 'Remaining Qty', T0.WhsCode, T3.ItmsGrpNam, T1.DistNumber

FROM OBTQ T0

INNER JOIN OBTN T1 ON T0.AbsEntry = T1.AbsEntry

INNER JOIN OITM T2 ON T0.ItemCode = T2.ItemCode

INNER JOIN OITB T3 ON T2.ItmsGrpCod = T3.ItmsGrpCod

WHERE T0.WhsCode ='01' AND (T0.Quantity-T0.CommitQty) > '0'

ORDER BY T3.ItmsGrpNam, T0.ItemCode

Kindly help for my requirement.

Regards,

Ravi.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

avatar image
Former Member Mar 22, 2017 at 08:09 AM
0

Did you get the answer already? I need know the answer as well .
Regards.
Jimmy

Share
10 |10000 characters needed characters left characters exceeded