成本计算检查通不过-用友U8

对应版本:用友U8.60sp对应产品线：供应链对应模块：销售管理模块问题现象:进行成本计算检查时提示数据类型不匹配，已打过成本管理的补丁，但无效。问题原因：您好，此问题研发人员已经出具相关补丁,补丁为KB-U860SP-0058-061130-93885.msi请使用下载中心【补丁编号1835：补丁自动更新工具】安装补丁解决此问题；一。关于成本检查报错的问题，已经转开发部处理，补丁已经做出来了,补丁发布后请使用自动更新补丁。二。关于使用自动更新工具升级数据库报错的问题，需要处理如下：请提前做好数据备份请对应执行对应的更新语句后可以进行升级。升级后可以解决生产订单手工输入的问题。这些脚本只能执行一次，不能重复执行：这里的环境是：win2000srv,860sp+所有正式发布的补丁。--1.voucheritems需要追加记录。insertintovoucheritems(VT_ID,CardNum,CardItemNum,CardItemName,CanNotSelect,ShowIt,LinkIt,LinkTbl,LinkField,TableName,FieldName,FieldType,ReferType,ReferTable,CardSection,CardFormula1,CardFormula2,CanModify,MaxLength,MaxShowLen,NumPoint,IsNull,CanDelete,UserCheck,UserPrompt,FormatChar,IsMain,NeedSum,CalcField,AliasNum,isSelfDef,COX,COY,Width,Height,TabIndex,DefaultValue,IsFixedLenght,FormatData,FontState,PrintCaption,PrintUpcase,PrintInterval,DataSource,EnterType,DataRule,ValidityCheck,ReserveSegTitlePos,BuildArchives,ReferReturnField,cmemo,nBorder)values(’8169’,’26’,’222’,’供应商全称’,0,0,0,NULL,NULL,’Vendor’,’cvenname’,1,1,’Vendor’,’T’,’供应商全称’,’供应商全称’,0,20,1300,0,0,2,NULL,NULL,NULL,1,0,0,0,0,NULL,7568,2500,NULL,NULL,NULL,NULL,NULL,’宋体,9,0,0,1’,1,0,NULL,0,0,NULL,0,1,0,NULL,NULL,0)--2.voucheritems需要追加记录。insertintovoucheritems(VT_ID,CardNum,CardItemNum,CardItemName,CanNotSelect,ShowIt,LinkIt,LinkTbl,LinkField,TableName,FieldName,FieldType,ReferType,ReferTable,CardSection,CardFormula1,CardFormula2,CanModify,MaxLength,MaxShowLen,NumPoint,IsNull,CanDelete,UserCheck,UserPrompt,FormatChar,IsMain,NeedSum,CalcField,AliasNum,isSelfDef,COX,COY,Width,Height,TabIndex,DefaultValue,IsFixedLenght,FormatData,FontState,PrintCaption,PrintUpcase,PrintInterval,DataSource,EnterType,DataRule,ValidityCheck,ReserveSegTitlePos,BuildArchives,ReferReturnField,cmemo,nBorder)values(’8169’,’26’,’223’,’关闭人’,0,1,0,NULL,NULL,’pu_arrivalvouch’,’ccloser’,1,5,’’,’T’,’关闭人’,’关闭人’,0,20,1300,0,0,2,NULL,NULL,NULL,1,0,0,0,0,NULL,7569,2500,NULL,NULL,NULL,NULL,NULL,’宋体,9,0,0,1’,1,0,NULL,0,0,NULL,0,1,0,NULL,NULL,0)--3.mom_moallocate表改表设计ALTERTABLEmom_moallocateADD[Define22][nvarchar](60)COLLATEChinese_PRC_CI_ASNULLALTERTABLEmom_moallocateADD[Define23][nvarchar](60)COLLATEChinese_PRC_CI_ASNULLALTERTABLEmom_moallocateADD[Define24][nvarchar](60)COLLATEChinese_PRC_CI_ASNULLALTERTABLEmom_moallocateADD[Define25][nvarchar](60)COLLATEChinese_PRC_CI_ASNULLALTERTABLEmom_moallocateADD[Define26][real]NULLALTERTABLEmom_moallocateADD[Define27][real]NULLALTERTABLEmom_moallocateADD[Define28][nvarchar](120)COLLATEChinese_PRC_CI_ASNULLALTERTABLEmom_moallocateADD[Define29][nvarchar](120)COLLATEChinese_PRC_CI_ASNULLALTERTABLEmom_moallocateADD[Define30][nvarchar](120)COLLATEChinese_PRC_CI_ASNULLALTERTABLEmom_moallocateADD[Define31][nvarchar](120)COLLATEChinese_PRC_CI_ASNULLALTERTABLEmom_moallocateADD[Define32][nvarchar](120)COLLATEChinese_PRC_CI_ASNULLALTERTABLEmom_moallocateADD[Define33][nvarchar](120)COLLATEChinese_PRC_CI_ASNULLALTERTABLEmom_moallocateADD[Define34][int]NULLALTERTABLEmom_moallocateADD[Define35][int]NULLALTERTABLEmom_moallocateADD[Define36][datetime]NULLALTERTABLEmom_moallocateADD[Define37][datetime]NULL--4.tmp_bomcomponent表改表设计ALTERTABLEtmp_bomcomponentADD[MoDId][int]NULL解决方案：您好，此问题研发人员已经出具相关补丁,补丁为KB-U860SP-0058-061130-93885.msi请使用下载中心【补丁编号1835：补丁自动更新工具】安装补丁解决此问题；一。关于成本检查报错的问题，已经转开发部处理，补丁已经做出来了,补丁发布后请使用自动更新补丁。二。关于使用自动更新工具升级数据库报错的问题，需要处理如下：请提前做好数据备份请对应执行对应的更新语句后可以进行升级。升级后可以解决生产订单手工输入的问题。这些脚本只能执行一次，不能重复执行：这里的环境是：win2000srv,860sp+所有正式发布的补丁。--1.voucheritems需要追加记录。insertintovoucheritems(VT_ID,CardNum,CardItemNum,CardItemName,CanNotSelect,ShowIt,LinkIt,LinkTbl,LinkField,TableName,FieldName,FieldType,ReferType,ReferTable,CardSection,CardFormula1,CardFormula2,CanModify,MaxLength,MaxShowLen,NumPoint,IsNull,CanDelete,UserCheck,UserPrompt,FormatChar,IsMain,NeedSum,CalcField,AliasNum,isSelfDef,COX,COY,Width,Height,TabIndex,DefaultValue,IsFixedLenght,FormatData,FontState,PrintCaption,PrintUpcase,PrintInterval,DataSource,EnterType,DataRule,ValidityCheck,ReserveSegTitlePos,BuildArchives,ReferReturnField,cmemo,nBorder)values(’8169’,’26’,’222’,’供应商全称’,0,0,0,NULL,NULL,’Vendor’,’cvenname’,1,1,’Vendor’,’T’,’供应商全称’,’供应商全称’,0,20,1300,0,0,2,NULL,NULL,NULL,1,0,0,0,0,NULL,7568,2500,NULL,NULL,NULL,NULL,NULL,’宋体,9,0,0,1’,1,0,NULL,0,0,NULL,0,1,0,NULL,NULL,0)--2.voucheritems需要追加记录。insertintovoucheritems(VT_ID,CardNum,CardItemNum,CardItemName,CanNotSelect,ShowIt,LinkIt,LinkTbl,LinkField,TableName,FieldName,FieldType,ReferType,ReferTable,CardSection,CardFormula1,CardFormula2,CanModify,MaxLength,MaxShowLen,NumPoint,IsNull,CanDelete,UserCheck,UserPrompt,FormatChar,IsMain,NeedSum,CalcField,AliasNum,isSelfDef,COX,COY,Width,Height,TabIndex,DefaultValue,IsFixedLenght,FormatData,FontState,PrintCaption,PrintUpcase,PrintInterval,DataSource,EnterType,DataRule,ValidityCheck,ReserveSegTitlePos,BuildArchives,ReferReturnField,cmemo,nBorder)values(’8169’,’26’,’223’,’关闭人’,0,1,0,NULL,NULL,’pu_arrivalvouch’,’ccloser’,1,5,’’,’T’,’关闭人’,’关闭人’,0,20,1300,0,0,2,NULL,NULL,NULL,1,0,0,0,0,NULL,7569,2500,NULL,NULL,NULL,NULL,NULL,’宋体,9,0,0,1’,1,0,NULL,0,0,NULL,0,1,0,NULL,NULL,0)--3.mom_moallocate表改表设计ALTERTABLEmom_moallocateADD[Define22][nvarchar](60)COLLATEChinese_PRC_CI_ASNULLALTERTABLEmom_moallocateADD[Define23][nvarchar](60)COLLATEChinese_PRC_CI_ASNULLALTERTABLEmom_moallocateADD[Define24][nvarchar](60)COLLATEChinese_PRC_CI_ASNULLALTERTABLEmom_moallocateADD[Define25][nvarchar](60)COLLATEChinese_PRC_CI_ASNULLALTERTABLEmom_moallocateADD[Define26][real]NULLALTERTABLEmom_moallocateADD[Define27][real]NULLALTERTABLEmom_moallocateADD[Define28][nvarchar](120)COLLATEChinese_PRC_CI_ASNULLALTERTABLEmom_moallocateADD[Define29][nvarchar](120)COLLATEChinese_PRC_CI_ASNULLALTERTABLEmom_moallocateADD[Define30][nvarchar](120)COLLATEChinese_PRC_CI_ASNULLALTERTABLEmom_moallocateADD[Define31][nvarchar](120)COLLATEChinese_PRC_CI_ASNULLALTERTABLEmom_moallocateADD[Define32][nvarchar](120)COLLATEChinese_PRC_CI_ASNULLALTERTABLEmom_moallocateADD[Define33][nvarchar](120)COLLATEChinese_PRC_CI_ASNULLALTERTABLEmom_moallocateADD[Define34][int]NULLALTERTABLEmom_moallocateADD[Define35][int]NULLALTERTABLEmom_moallocateADD[Define36][datetime]NULLALTERTABLEmom_moallocateADD[Define37][datetime]NULL--4.tmp_bomcomponent表改表设计ALTERTABLEtmp_bomcomponentADD[MoDId][int]NULL

本文链接：https://www.bbsufida.com/u8/46227.html