特价活动:>>>> 畅云管家新购、续费7折优惠,畅捷通T+cloud、好会计、易代账、好业财、好生意云产品8折优惠。
解决方案:
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、重新进行计划成本计算即可。
客服电话:400-665-0028
关键字:用友财务软件,畅捷通软件,财务软件,进销存软件,U9官网,用友U8,用友T1,用友T+,用友T3,用友T6,畅捷通好会计,好生意,智+好业财,用友培训服务售后公司,畅捷通运营培训服务公司
版权所有:用友畅捷通软件 Copyright © 2025 All rights reserved.