【问题描述】

生产任务单入库数量不对，与下游的产品入库单合计数不等。

【解决方案】

根据生产任务单下游的产品入库单，更新任务单入库数量

--审核更新库存，更新任务单入库数量
IF  EXISTS ( select 1 from t_SystemProfile where FKey='UPSTOCKWHENSAVE' and FValue=0)
BEGIN
update m set FStockQty=ISNULL(s.fqty,0),FAuxStockQty=ISNULL(s.FAuxQty,0)
from icmo m left join(
select FICMOInterID,sum(a.fqty)as fqty,sum(a.FAuxQty)FAuxQty
from ICStockBillEntry a join ICStockBill b on a.finterid=b.finterid
where b.FTranType=2 and FICMOInterID>0 and b.FStatus>0 and b.FCancellation=0
group by FICMOInterID )s on m.finterid=s.ficmointerid
where FStockQty<>ISNULL(s.fqty,0)
END
GO
--保存更新库存，更新任务单入库数量
IF NOT EXISTS (select 1 from t_SystemProfile where FKey='UPSTOCKWHENSAVE' and FValue=0 )
BEGIN
update m set FStockQty=ISNULL(s.fqty,0),FAuxStockQty=ISNULL(s.FAuxQty,0)
from icmo m left join(
select FICMOInterID,sum(a.fqty)as fqty,sum(a.FAuxQty)FAuxQty
from ICStockBillEntry a join ICStockBill b on a.finterid=b.finterid
where b.FTranType=2 and FICMOInterID>0 and b.FCancellation=0
group by FICMOInterID )s on m.finterid=s.ficmointerid
where FStockQty<>ISNULL(s.fqty,0)
END
GO

【注意事项】

正式账套执行脚本前请先做好备份，建议待在测试账套中核实无误后再在正式账套中执行。