How to get invenory in warehouse report branchwise??

[Former Member]

How to get inventory in warehouse report branch wise not warehouse wise in sap b1???We have more than one ware house in a single location.Can anyone give me a query for his ???

[Former Member]

Hi,

Try:

select t0.Location,t1.WhsName,t3.ItemCode,Max(t3.ItemName) 'Item Description', SUM(t3.OnHand) 'In Stock'

from OLCT t0

inner join OWHS t1 on t0.Code = t1.location

inner join OITW t2 on t1.WhsCode=t2.WhsCode

inner join OITM t3 on t2.ItemCode = t3.ItemCode

GROUP BY t0.Location,t1.WhsName,t3.ItemCode

Thanks,

Gordon

[Former Member]

Hi Nabil Rashidm,

This will gives you location wise report....

select location,WhsName,ItemCode,SUM(OnHand) from(

select t0.Location,t1.WhsName,t3.ItemCode,t3.ItemName,t3.OnHand  from OLCT t0

inner join OWHS t1 on t0.Code = t1.location 

inner join OITW t2 on t1.WhsCode=t2.WhsCode

inner join OITM t3 on t2.ItemCode = t3.ItemCode )locationReport group by location,WhsName,ItemCode

hope helpfull

Thanks and Regards

DEV

[kothandaraman_nagarajan]

Hi,

Try this query:

SELECT
T0.[ItemCode], T0.[ItemName], T0.[OnHand], T0.[IsCommited],
T0.[OnOrder],max(T3.[DocDate]) as LastReceiptdate,max( T5.[DocDate])
as Lastissuedate

FROM
OITM T0  left JOIN OINM T1 ON T0.ItemCode = T1.ItemCode left JOIN
IGN1 T2 ON T0.ItemCode = T2.ItemCode left JOIN OIGN T3 ON T2.DocEntry
= T3.DocEntry left JOIN DLN1 T4 ON T0.ItemCode = T4.ItemCode left
JOIN ODLN T5 ON T4.DocEntry = T5.DocEntry

WHERE
T0.[ItemCode] = [%0]

GROUP
BY T0.[ItemCode], T0.[ItemName], T0.[OnHand], T0.[IsCommited],
T0.[OnOrder]

Thanks & Regards,

Nagarajan