cancel
Showing results for 
Search instead for 
Did you mean: 

How to Read items onhand warehouse wise using ServiceLayer ?

former_member209771
Active Participant
0 Kudos

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

Accepted Solutions (0)

Answers (0)