Skip to Content

How to Read items onhand warehouse wise using ServiceLayer ?

Hi Expert ,

I want to Get item Onhand quantity warehouse wise using service layer. Before i have used the query for diserver below is the query :

select WareHouse.ItemCode, WhsCode,U_WebID,OnHandWareHouse ,WareHouse.U_LastStock from OITM inner join (select OITW.ItemCode, WhsCode,sum(OITW.OnHand-OITW.IsCommited) as OnHandWareHouse,OITW.U_LastStock FROM OITW where WhsCode in ('01','04') GROUP BY OITW.ItemCode , OITW.WhsCode,OITW.U_LastStock ) as WareHouse on WareHouse.ItemCode=OITM.ItemCode where OnHandWareHouse != (isnull(WareHouse.U_LastStock,0))

Please help how to write same query in Service Layer .

Thanks and Regards

Surajit Kundu

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers