on 11-29-2017 8:01 AM
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
User | Count |
---|---|
91 | |
8 | |
7 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.