【问题描述】

委外加工入库单核销方式按委外订单逐条核销核销时，委外加工出库单显示不全或不对。

【原因分析】

原因：委外加工出库单（委外加工入库单）记录的源单信息FOrderEntryID，FOrderDetailID异常。

【解决方案】

IF  EXISTS ( select 1 from syscolumns where name = 'FOrderDetailID' and id = object_id('ICStockBillEntry') )
BEGIN
update b set FOrderDetailID=c.FDetailID,FOrderEntryID =c.FEntryID
from ICStockBill a left join ICStockBillEntry b on a.FInterID=b.FInterID
left join ICSubContractEntry c on c.FInterID=b.FOrderInterID and c.FDetailID=b.FSourceEntryID
where a.FTranType in (5,28)  and b.FOrderInterID>0
and b.FOrderDetailID<>c.FDetailID
END
GO
IF NOT EXISTS ( select 1 from syscolumns where name = 'FOrderDetailID' and id = object_id('ICStockBillEntry') )
BEGIN
update b set FOrderEntryID =c.FEntryID
from ICStockBill a left join ICStockBillEntry b on a.FInterID=b.FInterID
left join ICSubContractEntry c on c.FInterID=b.FOrderInterID and c.FDetailID=b.FSourceEntryID
where a.FTranType in (5,28)  and b.FOrderInterID>0
and b.FOrderEntryID<>c.FEntryID
END
GO

【注意事项】

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