解决方案:
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+ IDENT+IT+Y_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=''
4、重新进行计划成本计算即可。