| 解决方案： |
1、参照执行如下脚本，将“材料单位转换率定义”中缺少的记录补充上去：
create view tp as
SELECT Inventory.cinvcode as 存货编码 , CA_AWPC.camoID AS 成本材料编码, CA_AWPC.cUnit AS 成本材料单位,ComputationUnit.cComUnitName AS 实际存货单位
FROM Inventory INNER JOIN ComputationUnit ON Inventory.cComUnitCode = ComputationUnit.cComunitCode
INNER JOIN CA_AWPC ON Inventory.cInvCode = CA_AWPC.camoID
where CA_AWPC.cUnit<>ComputationUnit.cComUnitName
and CA_AWPC.camoID not in(select distinct cmatid from CA_matdf)
go
SET IDENTITY_INSERT CA_MatDf ON
GO
INSERT INTO [UFDATA_007_2006].[dbo].[CA_MatDf]([cMatID], [cUnit], [cSpecification], [iRat], [cComments], [cMatName])
select distinct camoid,cunit,cInvStd,1.0,null,cInvName from CA_AWPC a inner join inventory b on a.camoid=b.cinvcode
where camoid in (select distinct 成本材料编码 from tp) order by camoid
GO
SET IDENTITY_INSERT CA_MatDf OFF
GO
2、执行如下脚本查询出产品属性中没有定义工序的产品记录：
select * from CA_propt where cprocedureid=''
3、在产品属性定义中将未定义工序的产品按用户需求进行补充；
4、重新进行计划成本计算即可。
|