金蝶k3不用结账就可以查询以后期间的物料收发汇总表.pdf

金蝶 K3 不用结账就可以查询以后期间的物料收发汇总表 一般财务的成本计算会比库存盘点滞后，所以有时为了 查库存收发需要往往要再不结账的情况下查询报表，此表为 不用结账就能查看的物料收发汇总表 CREATE proc stkd_ 物料收发汇总表 @begdate datetime, @enddate datetime, @begstock varchar(50), @endstock varchar(50), @begitem varchar(100), @enditem varchar(100) asset nocount onselect @endstock=zzzzzz where @endstock= select @enditem=zzzzzz where @enditem=declare @year int,@period int,@bd varchar(12) select @year=fvalue from t_systemprofile where fcategory=ic and fkey=currentyear select @period=fvalue from t_systemprofile where fcategory=ic and fkey=currentperiod if((@year*12+@period)lt;(year(@begdate)*12+month(@beg date))) begin select @year=year(@begdate),@period=month(@begdate) end select @bd=cast(@year as varchar(4))+-+cast(@period as varchar(2))+-01create table #aa( fstock int, fstockna varchar(80), fitemid int, fnumber varchar(100), fname varchar(100), fmodel varchar(100), fbatchno varchar(50), funit varchar(50), fbeg decimal(18,4) default(0), fin decimal(18,4) default(0), fout decimal(18,4) default(0), fend decimal(18,4) default(0) )create table #bb( fstock int, fstockna varchar(80), fitemid int, fnumber varchar(100), fname varchar(100), fmodel varchar(100), fbatchno varchar(50), funit varchar(50), fbeg decimal(18,4) default(0), fin decimal(18,4) default(0), fout decimal(18,4) default(0), fend decimal(18,4) default(0) )insert into #aa(fstock,fitemid,fbatchno,fbeg) select fstockid,fitemid,fbatchno,sum(fbegqty) as fbeg from icinvbal where fyear=@year and fperiod=@period and fstockid in (select fitemid from t_stock where fnumbergt;=@begstock and fnumberlt;=@endstock) and fitemid in (select fitemid from t_icitem where fnumbergt;=@begitem and fnumberlt;=@enditem) group by fstockid,fitemid,fbatchno--select * from icinvbalinsert into #aa(fstock,fitemid,fbatchno,fbeg) select ice.fdcstockid, ice.fitemid,ice.fbatchno, sum(case when ic.ftrantype in (1,2,3,5,10,40,41) and ice.fdcstock