金蝶错误修复方法.docx

1、金蝶错误修复方法金蝶错误修复方法C:WindowsSystem32Netplwiz.exeC:WindowsSystem32netsh.exe金蝶错误解决1、-错误代码:3639(E37H)Source :Microsoft OLE DB Provider for SQL ServerDetail :对象名 t_FADeprPolicy 无效。或-打开科目时，只显示资产和负债两个类别，提示：类型不匹配错误代码:13(DH)Source :SystemDataLib成功的解决方法：IF NOT EXISTS (SELECT * FROM SYSOBJECTS WHERE ID = OBJECT_

2、ID(Nt_FADeprPolicy) and OBJECTPROPERTY(id, NIsUserTable) = 1) BEGIN CREATE TABLE t_FADeprPolicy ( FID int IDENTITY (1, 1), FNumber nvarchar(80) NOT NULL , FName nvarchar(80) NOT NULL , FLevel int NOT NULL , FParentId int NOT NULL , FDetail smallint NOT NULL , FAddDeprPolicy smallint NOT NULL DEFAULT

3、 (0), FAlterDeprPolicy smallint NOT NULL DEFAULT (0), FClearDeprPolicy smallint NOT NULL DEFAULT (0), FDefault smallint NOT NULL DEFAULT (0) ) ON PRIMARY ENDIF NOT EXISTS(SELECT 1 FROM sysobjects o, syscolumns c where o.id=c.id and o.name=t_FaCard and c.Name=FDeprPolicyID) Alter TABLE t_FaCard Add F

4、DeprPolicyID int NOT NULL DEFAULT (1)IF NOT EXISTS(SELECT 1 FROM sysobjects o, syscolumns c where o.id=c.id and o.name=t_fabalcard and c.Name=FCurrentEffect) alter table t_fabalcard add FCurrentEffect smallint NOT NULL DEFAULT (0) IF EXISTS (SELECT * FROM SYSOBJECTS WHERE ID = OBJECT_ID(Nvw_fa_card)

5、 and OBJECTPROPERTY(id, NIsView) = 1) Begin Drop View vw_fa_card EndGOCREATE VIEW vw_fa_card AS select al.FAlterID,al.FAssetID,al.FYear,al.FPeriod,al.FCleared,al.FNew,al.FAlterNum, al.FOtherAlter,al.FDate,al.FNeedVoucher,al.FExplanation,al.FPreparer, al.FChecker,card.FAssetNumber,card.FAssetName,car

6、d.FUnit,card.FModel, card.FManufacturer,card.FProductingArea,card.FVender,card.FBeginUseDate, card.FNum,card.FOrgVal,card.FAMiuValueRead,card.FOrgValBuy,card.FResidueVal,card.FAccumDepr, card.FAccumDeprBuy,card.FLifePeriods, card.FPeriodsUsed,card.FJobUnit,card.FModule,card.FBuildVoucher, card.FAdju

7、stOldDepr,card.FEconomyUseID,card.FLocationID,card.FGroupID, card.FAlterModeID,card.FStatusID,card.FDeprMethodID,card.FAssetAcctID, card.FDeprAcctID, policy.FID as FDeprPolicyID,policy.FName as FPolicyName,policy.FNumber as FPolicyNumber, eu.FNumber as FEconomyUseNumber,eu.FName as FEconomyUseName,

8、loc.FNumber as FLocationNumber,loc.FName as FLocationName, grp.FNumber as FGroupNumber,grp.FName as FGroupName, am.FNumber as FAlterModeNumber,am.FName as FAlterModeName, sta.FNumber as FStatusNumber,sta.FName as FStatusName, dm.FName as FDeprMethodName, act1.FNumber as FAssetAcctNumber,act1.FName a

9、s FAssetAcctName, act2.FNumber as FDeprAcctNumber,act2.FName as FDeprAcctName, isnull(vg.FName,) as FVchGroupName from t_FAAlter al left join t_FACard card on al.FAlterID=card.FAlterID left join t_FACardItem ci on al.FAlterID=ci.FAlterID left join t_FAEconomyUse eu on card.FEconomyUseID=eu.FID left

10、join t_FALocation loc on card.FLocationID=loc.FID left join t_FAGroup grp on card.FGroupID=grp.FID left join t_FAAlterMode am on card.FAlterModeID=am.FID left join t_FAStatus sta on card.FStatusID=sta.FID left join t_FADeprMethod dm on card.FDeprMethodID=dm.FID left join t_Account act1 on card.FAsse

11、tAcctID=act1.FAccountID left join t_Account act2 on card.FDeprAcctID=act2.FAccountID left join t_VoucherGroup vg on am.FVchGroupID=vg.FGroupID left join t_FADeprPolicy policy on card.FDeprPolicyID=policy.FID where ci.FAMulAlterClassID=0 GOdelete from t_DataFlowDetailFunc where FDetailFuncID = 30106I

12、NSERT INTO t_DataFlowDetailFunc(FDetailFuncID,FFuncName,FFuncName_CHT,FFuncName_EN,FSubFuncID,FIndex,FClassName,FClassParam,FIsNormal,FHelpCode,FVisible,FAcctType,FFuncType,FEnable,FShowName,FShowName_CHT,FShowName_EN)VALUES( 30106,折旧政策管理,折旧政策管理,折旧政策管理,301,6,0,CLFYHZB,1,-1,1,)IF EXISTS( SELECT 1 FRO

13、M t_FADeprPolicy WHERE FNumber=01 ) DELETE FROM t_FADeprPolicy WHERE FNumber=01 INSERT INTO t_FADeprPolicy(FNumber,FName,FLevel,FParentId,FDetail,FAddDeprPolicy,FAlterDeprPolicy,FClearDeprPolicy,FDefault) SELECT 01,常用折旧政策,1,0,1,1,1,1,1IF EXISTS(SELECT 1 FROM sysobjects o, syscolumns c where o.id=c.i

14、d and o.name=t_FaCard and c.Name=FDeprPolicyID) UPDATE t_FaCard SET FDeprPolicyID=1 WHERE FDeprPolicyID IS NullGODelete from t_LogFunction WHERE FFunctionID = C00208 InSert INTO t_LogFunction(FFunctionID,FSubSysID,FFunctionName,FFunctionName_CHT,FFunctionName_EN)Values(C00208,3,固定资产基础资料-折旧政策管理,固定資產基

15、礎資料折舊政策管理,Fixed Assets Master Data-Change Depreciation Policy)DELETE FROM t_SysFunction WHERE FFuncID=2121 AND FSubSysID=3 INSERT INTO t_SysFunction (FFuncID,FNumber,FSubSysID,FDescription,FDescription_cht,FDescription_en)VALUES (2121,FA118,3,增加折旧政策方案,增加折舊政策方案,) DELETE FROM t_SysFunction WHERE FFunc

16、ID=2122 AND FSubSysID=3 INSERT INTO t_SysFunction (FFuncID,FNumber,FSubSysID,FDescription,FDescription_cht,FDescription_en)VALUES (2122,FA119,3,编辑折旧政策方案,編輯折舊政策方案,)DELETE FROM t_SysFunction WHERE FFuncID=2123 AND FSubSysID=3 INSERT INTO t_SysFunction (FFuncID,FNumber,FSubSysID,FDescription,FDescripti

17、on_cht,FDescription_en)VALUES (2123,FA120,3,删除折旧政策方案,刪除折舊政策方案,)UPDATE t_DataFlowTimeStamp SET FName = FName IF NOT EXISTS(SELECT 1 FROM sysObjects WHERE name=pk_t_FADeprPolicy) ALTER TABLE t_FADeprPolicy WITH NOCHECK ADD CONSTRAINT pk_t_FADeprPolicy PRIMARY KEY CLUSTERED ( FID ) ON PRIMARYGO-2、固定资产卡

18、片做清理，保存时出现错误提示：可能由于网络问题，卡片保存失败，请重新保存！ 错误代码:1000(3E8H) Source :EBSFACard.Create 处理的方法：use 数据库名update dbo.t_FACard set FDeprPolicyID=(select FID from dbo.t_FADeprPolicy)-3、固定资产的新增中，折旧策略无法选择，会出错，解决方法：-Add By Wedison K3V10.4, 新增固定资产折旧政策表IF NOT EXISTS (SELECT * FROM SYSOBJECTS WHERE ID = OBJECT_ID(Nt_FAD

19、eprPolicy) and OBJECTPROPERTY(id, NIsUserTable) = 1) BEGIN CREATE TABLE t_FADeprPolicy ( FID int IDENTITY (1, 1), FNumber nvarchar(80) NOT NULL , -编号 FName nvarchar(80) NOT NULL , -名称 FLevel int NOT NULL , -级次 FParentId int NOT NULL , -父级id FDetail smallint NOT NULL , -是否明细级 FAddDeprPolicy smallint

20、NOT NULL DEFAULT (0), -卡片新增的折旧政策，1:当期新增当期计提折旧，0：当期新增下期计提折旧 FAlterDeprPolicy smallint NOT NULL DEFAULT (0), -卡片变动的折旧政策，1：当期变动当期生效，0：当期变动下期生效 FClearDeprPolicy smallint NOT NULL DEFAULT (0), -卡片清理的折旧政策，1：当期清理当期不再计提折旧，0：当期清理当期仍然计提折旧 FDefault smallint NOT NULL DEFAULT (0) -是否是默认的折旧政策方案，1：默认的折旧政策方案，0：非默认的

21、折旧政策方案 ) ON PRIMARY END-Add By Wedison K3V10.4,卡片信息表 增加【折旧政策字段】 2006-07-12 IF NOT EXISTS(SELECT 1 FROM sysobjects o, syscolumns c where o.id=c.id and o.name=t_FaCard and c.Name=FDeprPolicyID) Alter TABLE t_FaCard Add FDeprPolicyID int NOT NULL DEFAULT (1)-Add By Wedison K3V10.4,卡片每期信息表 增加【折旧政策是否影响当期

22、折旧的字段】 2006-08-01 IF NOT EXISTS(SELECT 1 FROM sysobjects o, syscolumns c where o.id=c.id and o.name=t_fabalcard and c.Name=FCurrentEffect) alter table t_fabalcard add FCurrentEffect smallint NOT NULL DEFAULT (0) -0:当期变动下期生效,当期新增下期折旧，其他:当期变动当期生效,当期新增当期折旧 -10.4 增加折旧政策信息字段IF EXISTS (SELECT * FROM SYSOB

23、JECTS WHERE ID = OBJECT_ID(Nvw_fa_card) and OBJECTPROPERTY(id, NIsView) = 1) Begin Drop View vw_fa_card EndGOCREATE VIEW vw_fa_card AS select al.FAlterID,al.FAssetID,al.FYear,al.FPeriod,al.FCleared,al.FNew,al.FAlterNum, al.FOtherAlter,al.FDate,al.FNeedVoucher,al.FExplanation,al.FPreparer, al.FChecke

24、r,card.FAssetNumber,card.FAssetName,card.FUnit,card.FModel, card.FManufacturer,card.FProductingArea,card.FVender,card.FBeginUseDate, card.FNum,card.FOrgVal,card.FAMiuValueRead,card.FOrgValBuy,card.FResidueVal,card.FAccumDepr, card.FAccumDeprBuy,card.FLifePeriods, card.FPeriodsUsed,card.FJobUnit,card

25、.FModule,card.FBuildVoucher, card.FAdjustOldDepr,card.FEconomyUseID,card.FLocationID,card.FGroupID, card.FAlterModeID,card.FStatusID,card.FDeprMethodID,card.FAssetAcctID, card.FDeprAcctID, policy.FID as FDeprPolicyID,policy.FName as FPolicyName,policy.FNumber as FPolicyNumber, eu.FNumber as FEconomy

26、UseNumber,eu.FName as FEconomyUseName, loc.FNumber as FLocationNumber,loc.FName as FLocationName, grp.FNumber as FGroupNumber,grp.FName as FGroupName, am.FNumber as FAlterModeNumber,am.FName as FAlterModeName, sta.FNumber as FStatusNumber,sta.FName as FStatusName, dm.FName as FDeprMethodName, act1.F

27、Number as FAssetAcctNumber,act1.FName as FAssetAcctName, act2.FNumber as FDeprAcctNumber,act2.FName as FDeprAcctName, isnull(vg.FName,) as FVchGroupName from t_FAAlter al left join t_FACard card on al.FAlterID=card.FAlterID left join t_FACardItem ci on al.FAlterID=ci.FAlterID left join t_FAEconomyUs

28、e eu on card.FEconomyUseID=eu.FID left join t_FALocation loc on card.FLocationID=loc.FID left join t_FAGroup grp on card.FGroupID=grp.FID left join t_FAAlterMode am on card.FAlterModeID=am.FID left join t_FAStatus sta on card.FStatusID=sta.FID left join t_FADeprMethod dm on card.FDeprMethodID=dm.FID

29、 left join t_Account act1 on card.FAssetAcctID=act1.FAccountID left join t_Account act2 on card.FDeprAcctID=act2.FAccountID left join t_VoucherGroup vg on am.FVchGroupID=vg.FGroupID left join t_FADeprPolicy policy on card.FDeprPolicyID=policy.FID where ci.FAMulAlterClassID=0 GO-主控台delete from t_DataFlo