发布于:2018-01-23 14:01:04
问题现象:成本管理中在做生成计划成本时,出现“单位无定义,请修改数据后重试”
解决方案: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、重新进行计划成本计算即可。