Skip to Content
avatar image
Former Member

Batchwise inventory report for selected date

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

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

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

    Add comment
    10|10000 characters needed characters exceeded