Skip to Content

How to Read items onhand warehouse wise using ServiceLayer ?

Nov 29, 2017 at 08:01 AM


avatar image

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

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

0 Answers