委外加工入库审核未成功解决办法.docx

---委外加工审核未成功的问题解决办法, ---可能原因是表 ICShop_ItemConsume 中FinterID的最大值问题，由于中间有表删除，一些流水号丢失，所以更新下最大值 select top 1 * from ICShop_ItemConsume order by FInterID desc select * from ICMaxNum where FTableName like ICShop_ItemConsume --- 保证最大值一致,如不是则更新 update ICMaxNum set FMaxNum = (select max(finterid) from ICShop_ItemConsume) where FTableName like ICShop_ItemConsume 以下代码为其中一列报错中抓取的过程 --Declare @FSouceTrantype as int Declare @WIPDeductMode as Decimal(28,10) --在制品扣减方式 Declare @bWriteMethod as Int --是否按标准数量 Declare @dRate as Decimal(28,10) --换算率 Declare @FWIPQty as Decimal(28,10) --在制品数量 Declare @FICMOInterID as int Declare @#Data797A90FE46DE4D3DB0887B4794F98159 table(FOrderInterID int , FOrderEntryID INT ,FItemID INT, FStockQty Decimal(28,10),FSecStockQty DECIMAL(28,10)) Insert into @#Data797A90FE46DE4D3DB0887B4794F98159 SELECT FOrderInterID,FOrderEntryID,FItemID,SUM(ISNULL(u2.FQty,0)) as FStockQty,SUM(ISNULL(u2.FSecQty,0)) AS FSecStockQty FROM ICStockBillEntry u2 WHERE u2.FICMoInterID = 0 AND u2.FOrderInterID0 AND u2.FInterID= 213494 GROUP BY FOrderInterID,FOrderEntryID,FItemID IF (select count(*) from @#Data797A90FE46DE4D3DB0887B4794F98159 ) 0 UPDATE u1 SET u1.FStockQty=ISNULL(u1.FStockQty,0)+ m2.FStockQty, u1.FAuxStockQty=ISNULL(u1.FAuxStockQty,0)+ m2.FStockQty/cast(t2.FCoEfficient as float), u1.FSecStockQty =ISNULL(u1.FSecStockQty,0)+ m2.FSecStockQty FROM ICSubContractEntry u1 INNER JOIN @#Data797A90FE46DE4D3DB0887B4794F98159 m2 on u1.FInterID=m2.FOrderInterID AND u1.FEntryID = m2.FOrderEntryID AND u1.FItemID=m2.FItemID INNER JOIN t_MeasureUnit t2 ON u1.FUnitID=t2.FMeasureUnitID UPDATE u1 SET u1.FBCommitQty=ISNULL(u1.FBCommitQty,0)+ m2.FBackQty, u1.FAuxBCommitQty=(ISNULL(u1.FBCommitQty,0)+ m2.FBackQty)/cast(t2.FCoEfficient as float), u1.FSecBCommitQty=ISNULL(u1.FSecBCommitQty,0)+m2.FSecBackQty FROM ICSubContractEntry u1 INNER JOIN (SELECT FOrderInterID,FOrderEntryID,FItemID,SUM(ISNULL(u2.FQty,0))