存货整理现存量.docVIP

存货整理现存量 GO IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N[dbo].[SP_Currentstock]) AND type in (NP, NPC)) DROP PROCEDURE [dbo].[SP_Currentstock] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE PROCEDURE [dbo].[SP_Currentstock] As declare @bMaterialOutCheck as nvarchar(10) declare @bOtherInCheck as nvarchar(10) declare @bOtherOutCheck as nvarchar(10) declare @bProductInCheck as nvarchar(10) declare @bPurchaseInCheck as nvarchar(10) declare @bSaleOutCheck as nvarchar(10) declare @bScrapcheck as nvarchar(10) declare @strErr as nvarchar(500) declare @LangId as nvarchar(50) declare @dststartdateAcc as datetime declare @dststartdate as datetime declare @dstfirstdate as datetime declare @dqmfirstdate as datetime DECLARE @Acc_Name nvarchar(50) declare @accid as nvarchar(8) declare @iyear as int --DECLARE @Acc_Name nvarchar(50) DECLARE @Acc_Iyear nvarchar(4) set @Acc_Name=DB_NAME() set @Acc_Iyear=RIGHT(@Acc_Name,4) set @Acc_Name=SUBSTRING(@Acc_Name,8,3) set @dqmfirstdate=Null set @dstfirstdate=convert(datetime,(select cvalue from accinformation where csysid=Nia and cname =Ndiafirstdate)) set @dststartdateAcc=convert(datetime,(select cvalue from accinformation where csysid=Nia and cname =Ndiastartdate)) set @bMaterialOutCheck=false set @bOtherInCheck=false set @bOtherOutCheck=false set @bProductInCheck=false set @bPurchaseInCheck=false set @bSaleOutCheck=false set @bscrapcheck=false execute ufsystem..sp_GetMonthPeriodFirst @Acc_Name,@dststartdateAcc,@dststartdate output --delete from tempcurrentstock truncate table tempcurrentstock --期初 insert into tempcurrentstock (cwhcode,cinvcode,iquantity,inum,cfree1,cfree2,foutquantity,foutnum, finquantity,finnum,cfree3,cfree4,cfree5,cfree6,cfree7,cfree8,cfree9,cfree10,cbatch,dvdate, ftransinquantity,dmdate,ftransinnum,ftransoutquantity,ftransoutnum,fplanquantity,fplannum, fdisablequantity,fdisablenum,favaquantity,favanum,imassdate,cm