物料启用保质期，后台修改取消保质期。

整体思路：1、将物料上保质期取消；

                    2、将单据上的保质期进行取消；

                    3、取消库房存货余额表上对应物料的保质期；

                    4、取消存货表上对应物料的保质期；        

                    5、处理完以后，在即时库存中进行对应物料库存校对；

附：相应代码  

注：在插入数据前一定要看清对应表中的字段是否与语句中一样，如果不相同需要进行相应修改。

--取消物料上的保质期

update t_ICItem set FISKFPeriod=0,FKFPeriod=0 where FNumber in(物料代码)

--查询库存明细

SELECT * FROM ICInvBal where fitemid=物料ID

--将库房存货余额表中对应物料库存明细先放入临时表

SELECT * INTO #ICInvBalFKFDate FROM ICInvBal where fitemid=物料ID

GO

--删除库房存货余额表中对应物料记录

delete  from ICInvBal where fitemid=物料ID

GO

--将临时表中数据取出来插入到库房存货余额表中（有进行合计）

INSERT INTO ICInvBal(FBrNo,FYear,FPeriod,FStockID,FItemID,FBatchNo,FBegQty,FReceive,FSend,FYtdReceive,FYtdSend

,FEndQty,FBegBal,FDebit,FCredit,FYtdDebit,FYtdCredit,FEndBal,FBegDiff,FReceiveDiff

,FSendDiff,FEndDiff,FBillInterID,FStockPlaceID,FKFPeriod,FKFDate,FYtdReceiveDiff,FYtdSendDiff

,FSecBegQty,FSecReceive,FSecSend,FSecYtdReceive,FSecYtdSend,FSecEndQty,FAuxPropID,FStockInDate,FMTONo,FSupplyID)

select FBrNo,FYear,FPeriod,FStockID,FItemID,FBatchNo,

SUM(FBegQty),SUM(FReceive),SUM(FSend),SUM(FYtdReceive),sum(FYtdSend),

SUM(FEndQty),SUM(fbegbal),SUM(fdebit),SUM(FCredit),SUM(FYtdDebit),

SUM(FYtdCredit),SUM(FEndBal),SUM(FBegDiff),SUM(FReceiveDiff),

SUM(FSendDiff),SUM(FEndDiff),FBillInterID,FStockPlaceID,0,'',

SUM(FYtdReceiveDiff),SUM(FYtdSendDiff),

SUM(FSecBegQty),SUM(FSecReceive),SUM(FSecSend),SUM(FSecYtdReceive),

sum(FSecYtdSend),SUM(FSecEndQty),

FAuxPropID,FStockInDate,FMTONo,FSupplyID

from #ICInvBalFKFDate  

group by FBrNo,FYear,FPeriod,FStockID,FItemID,FBatchNo,FBillInterID,FStockPla