DFWMS货位库存数量修改

--wms 库存查询

select Bindcode,dbo.Get_INnum(Ratio,INnum) as INnum,Sunit,Pname,Pmake,Pspec,MNE,Psort,Ratio,Batch,ProdDate,ExpiDate,SHYcode,b.GOname,a.PPOO
from WBV_WBT_Inventory a,WBT_GoodsOwner b 
where INnum>0 
and (Batch like '%030007%' or Bindcode like '%030007%' or Pname like '%030007%' or MNE like '%030007%' or SHYcode like '%030007%')
and a.GOID=b.GOID

--查询要修改数量的品种批号库存

select top 10 ProdDate,* from WBV_WBT_Inventory where INnum>0 and Batch like '%M230727%'

---查修改品种批号库存

update WBV_WBT_Inventory set INnum=0 where INnum>0 and Batch like '%M230727%'