发布时间:2026-10-9
特价活动:>>>> 用友U8、T6、T+、T3软件产品4折优惠,畅捷通T+cloud、好会计、好业财、好生意云产品8折优惠,另有话费赠送。
问题现象:成本管理中在做生成计划成本时,出现“单位无定义,请修改数据后重试”
解决方案:
1、参照执行如下脚本,将“材料单位转换率定义”中缺少的记录补充上去: create view tp as SELECT Ivetory.civcode as 存货编码 , CA_AWPC.camoID AS 成本材料编码, CA_AWPC.cUit AS 成本材料单位,ComputatioUit.cComUitame AS 实际存货单位 FROM Ivetory IER JOI ComputatioUit O Ivetory.cComUitCode = ComputatioUit.cComuitCode IER JOI CA_AWPC O Ivetory.cIvCode = CA_AWPC.camoID where CA_AWPC.cUit<>ComputatioUit.cComUitame ad CA_AWPC.camoID ot i(select distict cmatid from CA_matdf) go SET IDETITY_ISERT CA_MatDf O GO ISERT ITO [UFDATA_007_2006].[dbo].[CA_MatDf]([cMatID], [cUit], [cSpecificatio], [iRat], [cCommets], [cMatame]) select distict camoid,cuit,cIvStd,1.0,ull,cIvame from CA_AWPC a ier joi ivetory b o a.camoid=b.civcode where camoid i (select distict 成本材料编码 from tp) order by camoid GO SET IDETITY_ISERT CA_MatDf OFF GO
2、执行如下脚本查询出产品属性中没有定义工序的产品记录: select * from CA_propt where cprocedureid=''
3、在产品属性定义中将未定义工序的产品按用户需求进行补充;
4、重新进行计划成本计算即可。
截屏,微信识别二维码
客服QQ:5151867
(点击QQ号复制,添加好友)