金蝶錯誤修復方法

1、演講稿工作總結(jié)調(diào)研報告講話稿事跡材料心得體會策劃方案金蝶錯誤修復方法C:WindowsSystem32Netplwiz.exeC:WindowsSystem32netsh.exe金蝶錯誤解決1、-錯誤代碼 :3639(E37H)Source:Microsoft OLE DB Provider for SQL ServerDetail:對象名't_FADeprPolicy' 無效?；?打開科目時，只顯示資產(chǎn)和負債兩個類別，提示：類型不匹配錯誤代碼 :13(DH)Source:SystemDataLib成功的解決方法：IF NOT EXISTS (SELECT * FROM SYS

2、OBJECTS WHERE ID =OBJECT_ID(N't_FADeprPolicy') and OBJECTPROPERTY(id, N'IsUserTable')精心收集精心編輯精致閱讀如需請下載！演講稿工作總結(jié)調(diào)研報告講話稿事跡材料心得體會策劃方案= 1) BEGINCREATE TABLE t_FADeprPolicy(FIDint IDENTITY (1, 1),FNumbernvarchar(80) NOT NULL ,FNamenvarchar(80) NOT NULL ,FLevelint NOT NULL ,FParentIdint NOT

3、 NULL ,FDetailsmallint NOT NULL ,FAddDeprPolicysmallint NOT NULL DEFAULT (0),FAlterDeprPolicysmallint NOT NULL DEFAULT (0),FClearDeprPolicy smallint NOT NULL DEFAULT (0),FDefaultsmallint NOT NULL DEFAULT (0) ON PRIMARYENDIF NOT EXISTS(SELECT 1 FROM sysobjects o, syscolumns c where o.id=c.id and o.na

4、me='t_FaCard' and c.Name='FDeprPolicyID')Alter TABLE t_FaCard Add FDeprPolicyID int NOT NULL DEFAULT (1)IF NOT EXISTS(SELECT 1 FROM sysobjects o, syscolumns c where o.id=c.id精心收集精心編輯精致閱讀如需請下載！演講稿工作總結(jié)調(diào)研報告講話稿事跡材料心得體會策劃方案and ='t_fabalcard' and c.Name='FCurrentEffect

5、9;)alter table t_fabalcard add FCurrentEffect smallint NOT NULL DEFAULT(0)IFEXISTS (SELECT * FROM SYSOBJECTS WHERE ID =OBJECT_ID(N'vw_fa_card') and OBJECTPROPERTY(id, N'IsView') = 1) BeginDrop View vw_fa_cardEndGOCREATEVIEWvw_fa_card ASselectal.FAlterID,al.FAssetID,al.FYear,al.FPerio

6、d,al.FCleared,al.FNew,al.FAlterNum,al.FOtherAlter,al.FDate,al.FNeedVoucher,al.FExplanation,al.FPreparer,al.FChecker,card.FAssetNumber,card.FAssetName,card.FUnit,card.FModel,card.FManufacturer,card.FProductingArea,card.FVender,card.FBeginUseDate,card.FNum,card.FOrgVal,card.FAMiuValueRead,card.FOrgVal

7、Buy,card.FRe精心收集精心編輯精致閱讀如需請下載！演講稿工作總結(jié)調(diào)研報告講話稿事跡材料心得體會策劃方案sidueVal,card.FAccumDepr,card.FAccumDeprBuy,card.FLifePeriods,card.FPeriodsUsed,card.FJobUnit,card.FModule,card.FBuildVoucher,card.FAdjustOldDepr,card.FEconomyUseID,card.FLocationID,card.FGroupID,card.FAlterModeID,card.FStatusID,card.FDeprMetho

8、dID,card.FAssetAcctID,card.FDeprAcctID,policy.FID as FDeprPolicyID,policy.FName as FPolicyName,policy.FNumber as FPolicyNumber,eu.FNumber as FEconomyUseNumber,eu.FName as FEconomyUseName,loc.FNumber as FLocationNumber,loc.FName as FLocationName, grp.FNumber as FGroupNumber,grp.FName as FGroupName, a

9、m.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 as FAssetAcctName, act2.FNumber as FDeprAcctNumber,act2.FName as FDeprAcctName, isnull(vg.FName,'') as FVch

10、GroupName精心收集精心編輯精致閱讀如需請下載！演講稿工作總結(jié)調(diào)研報告講話稿事跡材料心得體會策劃方案from t_FAAlter alleft join t_FACard card on al.FAlterID=card.FAlterID left join t_FACardItem ci on al.FAlterID=ci.FAlterIDleft join t_FAEconomyUse eu on card.FEconomyUseID=eu.FID left join t_FALocation loc on card.FLocationID=loc.FID left join t_F

11、AGroup grp on card.FGroupID=grp.FIDleft join t_FAAlterMode am on card.FAlterModeID=am.FID left join t_FAStatus sta on card.FStatusID=sta.FIDleft join t_FADeprMethod dm on card.FDeprMethodID=dm.FID left join t_Account act1 on card.FAssetAcctID=act1.FAccountID left join t_Account act2 on card.FDeprAcc

12、tID=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=0GOdelete from t_DataFlowDetailFuncwhere FDetailFuncID = 30106INSERT INTOt_DataFlowDetailFunc(FDetailFuncID,FFuncName,FFuncName_CH

13、T,FFunc Name_EN,FSubFuncID,FIndex,FClassName,FClassParam,FIsNormal,FHelp Code,FVisible,FAcctType,FFuncType,FEnable,FShowName,FShowName_C HT,FShowName_EN)精心收集精心編輯精致閱讀如需請下載！演講稿工作總結(jié)調(diào)研報告講話稿事跡材料心得體會策劃方案VALUES( 30106,'折舊政策管理 ','折舊政策管理 ',' 折舊政策管理',301,6,'','',0,'

14、CLFYHZB',1,'',-1,1,'','','')IF EXISTS( SELECT1 FROM t_FADeprPolicy WHERE FNumber='01' )DELETE FROM t_FADeprPolicyWHERE FNumber='01'INSERT INTOt_FADeprPolicy(FNumber,FName,FLevel,FParentId,FDetail,FAddDeprPolicy,FAlterDeprPolicy,FClearDeprPolicy,FDe

15、fault)SELECT '01','常用折舊政策 ',1,0,1,1,1,1,1IF EXISTS(SELECT 1 FROM sysobjects o, syscolumns c where o.id=c.id and ='t_FaCard' and c.Name='FDeprPolicyID')UPDATE t_FaCard SET FDeprPolicyID=1 WHERE FDeprPolicyID IS NullGODelete from t_LogFunction WHERE FFunctionID =

16、'C00208' InSert INTOt_LogFunction(FFunctionID,FSubSysID,FFunctionName,FFunctionName_ CHT,FFunctionName_EN)Values('C00208',3,'固定資產(chǎn)基礎(chǔ)資料 -折舊政策管理 ','固定資產(chǎn)基礎(chǔ)資料折舊政策管理 ','Fixed Assets Master Data-Change Depreciation Policy')DELETE FROM t_SysFunction WHERE FFuncID=2121

17、 AND FSubSysID=3精心收集精心編輯精致閱讀如需請下載！演講稿工作總結(jié)調(diào)研報告講話稿事跡材料心得體會策劃方案INSERT INTO t_SysFunction(FFuncID,FNumber,FSubSysID,FDescription,FDescription_cht,FDescription_en)VALUES (2121,'FA118',3,'增加折舊政策方案 ','增加折舊政策方案 ','')DELETE FROM t_SysFunction WHERE FFuncID=2122 AND FSubSysID=3

18、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=3INSERT INTO t_SysFunction(FFuncID,FNumber,FSubSysID,FDescrip

19、tion,FDescription_cht,FDescription_en)VALUES (2123,'FA120',3,'刪除折舊政策方案 ','刪除折舊政策方案 ','')UPDATE t_DataFlowTimeStamp SET FName = FNameIF NOT EXISTS(SELECT 1 FROM sysObjects WHERE name='pk_t_FADeprPolicy')ALTER TABLE t_FADeprPolicy WITH NOCHECK ADD CONSTRAINT pk_

20、t_FADeprPolicy PRIMARY KEYCLUSTERED(精心收集精心編輯精致閱讀如需請下載！演講稿工作總結(jié)調(diào)研報告講話稿事跡材料心得體會策劃方案FID)ON PRIMARYGO-2、固定資產(chǎn)卡片做清理， 保存時出現(xiàn)錯誤提示： 可能由于網(wǎng)絡(luò)問題，卡片保存失敗，請重新保存！錯誤代碼 :1000(3E8H)Source :EBSFACard.Create處理的方法：use 數(shù)據(jù)庫名update dbo.t_FACard set FDeprPolicyID=(select FID fromdbo.t_FADeprPolicy)-3、固定資產(chǎn)的新增中，折舊策略無法選擇，會出錯，解決方法：

21、-Add By Wedison K3V10.4, 新增固定資產(chǎn)折舊政策表IF NOT EXISTS (SELECT * FROM SYSOBJECTS WHERE ID =OBJECT_ID(N't_FADeprPolicy') and OBJECTPROPERTY(id, N'IsUserTable')精心收集精心編輯精致閱讀如需請下載！演講稿工作總結(jié)調(diào)研報告講話稿事跡材料心得體會策劃方案= 1) BEGINCREATE TABLE t_FADeprPolicy(FIDint IDENTITY (1, 1),FNumbernvarchar(80) NOT NU

22、LL ,-編號FNamenvarchar(80) NOT NULL ,-名稱FLevelint NOT NULL ,-級次FParentIdint NOT NULL ,-父級 idFDetailsmallint NOT NULL ,-是否明細級FAddDeprPolicy smallint NOT NULL DEFAULT (0), -卡片新增的折舊政策， 1:當期新增當期計提折舊，0：當期新增下期計提折舊FAlterDeprPolicysmallint NOT NULL DEFAULT (0), -卡片變動的折舊政策， 1：當期變動當期生效， 0：當期變動下期生效 FClearDeprPol

23、icy smallint NOT NULL DEFAULT (0), -卡片清理的折舊政策， 1：當期清理當期不再計提折舊， 0：當期清理當期仍然計提折舊FDefaultsmallint NOT NULL DEFAULT (0)是-否是默認的折舊政策方案， 1：默認的折舊政策方案， 0：非默認的折舊政策方案) ON PRIMARY精心收集精心編輯精致閱讀如需請下載！演講稿工作總結(jié)調(diào)研報告講話稿事跡材料心得體會策劃方案END-Add By Wedison K3V10.4,卡片信息表增加【折舊政策字段】2006-07-12IF NOT EXISTS(SELECT 1 FROM sysobjects

24、 o, syscolumns c where o.id=c.id and ='t_FaCard' and c.Name='FDeprPolicyID')Alter TABLE t_FaCard Add FDeprPolicyID int NOT NULL DEFAULT(1)-Add By Wedison K3V10.4,卡片每期信息表增加【折舊政策是否影響當期折舊的字段】2006-08-01IF NOT EXISTS(SELECT 1 FROM sysobjects o, syscolumns c where o.id=c.id and o.nam

25、e='t_fabalcard' and c.Name='FCurrentEffect')alter table t_fabalcard add FCurrentEffect smallint NOT NULL DEFAULT (0) -0:當期變動下期生效 ,當期新增下期折舊， 其他 :當期變動當期生效 ,當期新增當期折舊-10.4 增加折舊政策信息字段IFEXISTS (SELECT * FROM SYSOBJECTS WHERE ID =精心收集精心編輯精致閱讀如需請下載！演講稿工作總結(jié)調(diào)研報告講話稿事跡材料心得體會策劃方案OBJECT_ID(N'v

26、w_fa_card') and OBJECTPROPERTY(id, N'IsView') = 1)BeginDrop View vw_fa_cardEndGOCREATEVIEWvw_fa_card ASselectal.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,car

27、d.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.FModule,card.FBuildVoucher

28、,card.FAdjustOldDepr,card.FEconomyUseID,card.FLocationID,card.FGr精心收集精心編輯精致閱讀如需請下載！演講稿工作總結(jié)調(diào)研報告講話稿事跡材料心得體會策劃方案oupID,card.FAlterModeID,card.FStatusID,card.FDeprMethodID,card.FAssetAcctID,card.FDeprAcctID,policy.FID as FDeprPolicyID,policy.FName as FPolicyName,policy.FNumber as FPolicyNumber,eu.FNumber

29、 as FEconomyUseNumber,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 FDeprMethodN

30、ame,act1.FNumber as FAssetAcctNumber,act1.FName as FAssetAcctName,act2.FNumber as FDeprAcctNumber,act2.FName as FDeprAcctName, isnull(vg.FName,'') as FVchGroupName from t_FAAlter alleft join t_FACard card on al.FAlterID=card.FAlterID left join t_FACardItem ci on al.FAlterID=ci.FAlterIDleft j

31、oin t_FAEconomyUse eu on card.FEconomyUseID=eu.FID left join t_FALocation loc on card.FLocationID=loc.FID精心收集精心編輯精致閱讀如需請下載！演講稿工作總結(jié)調(diào)研報告講話稿事跡材料心得體會策劃方案left join t_FAGroup grp on card.FGroupID=grp.FIDleft join t_FAAlterMode am on card.FAlterModeID=am.FID left join t_FAStatus sta on card.FStatusID=sta.F

32、IDleft join t_FADeprMethod dm on card.FDeprMethodID=dm.FID 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

33、.FID where ci.FAMulAlterClassID=0GO-主控臺delete from t_DataFlowDetailFuncwhere FDetailFuncID = 30106INSERT INTOt_DataFlowDetailFunc(FDetailFuncID,FFuncName,FFuncName_CHT,FFunc Name_EN,FSubFuncID,FIndex,FClassName,FClassParam,FIsNormal,FHelp Code,FVisible,FAcctType,FFuncType,FEnable,FShowName,FShowName

34、_C HT,FShowName_EN)VALUES( 30106,'折舊政策管理 ','折舊政策管理 ',' 折舊政策管理',301,6,'','',0,'CLFYHZB',1,'',-1,1,'','','')精心收集精心編輯精致閱讀如需請下載！演講稿工作總結(jié)調(diào)研報告講話稿事跡材料心得體會策劃方案-主控臺-Begin t_FADeprPolicy 折舊政策預設(shè)數(shù)據(jù)IF EXISTS( SELECT1 FROM t_FADeprPoli

35、cy WHERE FNumber='01' )DELETE FROM t_FADeprPolicyWHERE FNumber='01'INSERT INTOt_FADeprPolicy(FNumber,FName,FLevel,FParentId,FDetail,FAddDeprPolicy,FAlterDeprPolicy,FClearDeprPolicy,FDefault)SELECT '01','常用折舊政策 ',1,0,1,1,1,1,1-Endt_FADeprPolicy 折舊政策預設(shè)數(shù)據(jù)IF EXISTS(SELECT

36、 1 FROM sysobjects o, syscolumns c where o.id=c.id and ='t_FaCard' and c.Name='FDeprPolicyID')UPDATE t_FaCard SET FDeprPolicyID=1 WHERE FDeprPolicyID IS NullGO-固定資產(chǎn)折舊政策權(quán)限使用固定資產(chǎn)基礎(chǔ)資料的權(quán)限（ FObjectType=30 and FObjectID =）1類似變動方式的權(quán)限精心收集精心編輯精致閱讀如需請下載！演講稿工作總結(jié)調(diào)研報告講話稿事跡材料心得體會策劃方案-折舊政策日志D

37、elete from t_LogFunction WHERE FFunctionID = 'C00208'InSert INTOt_LogFunction(FFunctionID,FSubSysID,FFunctionName,FFunctionName_CHT,FFunctionName_EN)Values('C00208',3,'固定資產(chǎn)基礎(chǔ)資料 -折舊政策管理 ','固定資產(chǎn)基礎(chǔ)資料折舊政策管理 ','Fixed Assets Master Data-Change DepreciationPolicy')-折

38、舊政策日志-折舊政策管理網(wǎng)絡(luò)控制DELETE FROM t_SysFunction WHERE FFuncID=2121 AND FSubSysID=3INSERT INTO t_SysFunction(FFuncID,FNumber,FSubSysID,FDescription,FDescription_cht,FDescription_en)VALUES (2121,'FA118',3,'增加折舊政策方案 ','增加折舊政策方案 ','')DELETE FROM t_SysFunction WHERE FFuncID=2122

39、 AND FSubSysID=3精心收集精心編輯精致閱讀如需請下載！演講稿工作總結(jié)調(diào)研報告講話稿事跡材料心得體會策劃方案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

40、INSERT INTO t_SysFunction(FFuncID,FNumber,FSubSysID,FDescription,FDescription_cht,FDescription_en)VALUES (2123,'FA120',3,'刪除折舊政策方案 ','刪除折舊政策方案 ','')-折舊政策管理網(wǎng)絡(luò)控制-最后執(zhí)行UPDATE t_DataFlowTimeStamp SET FName = FName-Begint_FADeprPolicy 記折舊政策表的主鍵索引精心收集精心編輯精致閱讀如需請下載！演講稿工作總結(jié)調(diào)研報

41、告講話稿事跡材料心得體會策劃方案*/*/IF NOT EXISTS(SELECT 1 FROM sysObjects WHERE name='pk_t_FADeprPolicy')ALTER TABLE t_FADeprPolicy WITH NOCHECK ADD CONSTRAINT pk_t_FADeprPolicy PRIMARY KEYCLUSTERED(FID)ON PRIMARYGO-Endt_FADeprPolicy記折舊政策表的主鍵索引-Total,PRJ00044685,取消計價方法后進先出法,當沒有物料的時候，新建賬套。IF NOT EXISTS (SEL

42、ECT TOP 1 FTrack FROM t_ICItem WHERE FTrack=79) DELETE FROM t_SubMessage WHERE FtypeID=200and FID='F004' GO-增加共同科目類別IF NOT EXISTS (SELECT 1 FROM t_AcctGroup WHERE FClassID=7)BEGIN精心收集精心編輯精致閱讀如需請下載！演講稿工作總結(jié)調(diào)研報告講話稿事跡材料心得體會策劃方案INSERT INTOt_AcctGroup(FClassID,FGroupID,FName,FName_Cht,FName_En) Va

43、lues(7,0,'共同 ',' 共同 ','Together')INSERT INTOt_AcctGroup(FClassID,FGroupID,FName,FName_Cht,FName_En) Values(7,700,'共同 ','共同 ','Together')ENDGO-ADD BY YOKI FOR GL012現(xiàn)金流量表項目的調(diào)整2006-09-20-通過以下判斷，控制僅在新建帳套或未使用過現(xiàn)金流量表的帳套中增加項目IF (NOT EXISTS(SELECT top 1 * FROM

44、t_VoucherEntry WHERE FCashFlowItem=1)AND (NOT EXISTS(SELECT top 1 * FROM t_CashFlowBal WHERE FItemID>0 or FSubItemID>0)AND (SELECT count(*) FROM t_Item WHERE FItemClassID=9)=54BEGIN-1、主表項目的改動 :DECLARE ItemID INT-修改類別：投資活動產(chǎn)生的現(xiàn)金流量現(xiàn)金流入精心收集精心編輯精致閱讀如需請下載！演講稿工作總結(jié)調(diào)研報告講話稿事跡材料心得體會策劃方案AND FItemClassID=9

45、)BEGIN-將“收到的其它與投資活動有關(guān)的現(xiàn)金”流量項目代碼修改為“”UPDATE t_Item SETSELECT ItemID=FItemID FROM t_Item WHERE FNumber='CI2.01' AND FItemCLassID=9-并新增“購買或處置子公司及其他營業(yè)單位產(chǎn)生的現(xiàn)金凈額”。INSERT INTO t_Item(FItemClassID,FNumber,FParentID,FLevel,FDetail,FName,FFullNumber,FShortNumber)購買或處置子公司及其他營業(yè)單位產(chǎn)生的現(xiàn)金凈額END-修改類別：投資活動產(chǎn)生的現(xiàn)

46、金流量現(xiàn)金流出AND FItemClassID=9)BEGIN-將“支付的其它與投資活動有關(guān)的現(xiàn)金”流量項目精心收集精心編輯精致閱讀如需請下載！演講稿工作總結(jié)調(diào)研報告講話稿事跡材料心得體會策劃方案代碼修改為“”UPDATE t_Item SETSELECT ItemID=FItemID FROM t_Item WHEREFNumber='CI2.02' AND FItemCLassID=9-新增現(xiàn)金流量項目： “取得子公司及其他營業(yè)單位支付的現(xiàn)金凈額”。INSERT INTO t_Item(FItemClassID,FNumber,FParentID,FLevel,FDetai

47、l,FName,FFullNumber,FShortNumber)取得子公司及其他營業(yè)單位支付的現(xiàn)金凈額END-2、附表項目的改動AND FItemClassID=9)BEGIN-將系統(tǒng)原至流量項目代碼均往后順延1。即：改為，改為UPDATE t_Item SET精心收集精心編輯精致閱讀如需請下載！演講稿工作總結(jié)調(diào)研報告講話稿事跡材料心得體會策劃方案UPDATE t_Item SETUPDATE t_Item SETUPDATE t_Item SETUPDATE t_Item SETUPDATE t_Item SET-并新增流量項目：“公允價值變動損益”SELECT ItemID=FItemI

48、D FROM t_Item WHEREFNumber='CI5.01' AND FItemCLassID=9精心收集精心編輯精致閱讀如需請下載！演講稿工作總結(jié)調(diào)研報告講話稿事跡材料心得體會策劃方案INSERT INTO t_Item(FItemClassID,FNumber,FParentID,FLevel,FDetail,FName,FFullNumber,FShortNumber)公允價值變動損益ENDENDGO-ADD BY YOKI FOR CF012老的現(xiàn)金流量表系統(tǒng)中流量項目的調(diào)整2006-10-10-1、主表項目的改動 :-修改類別：投資活動產(chǎn)生的現(xiàn)金流量現(xiàn)金流入-新增“處置子公司及其他營業(yè)單位收到的現(xiàn)金凈額”,放在“收到的其它與投資活動有關(guān)的現(xiàn)金”之前-修改類別：投資活動產(chǎn)生的現(xiàn)金流量現(xiàn)金流出-新增現(xiàn)金流量項目： “取得子公司及其他營業(yè)單位支付的現(xiàn)金凈額” ,放在“支付的其它與投資活動有關(guān)的現(xiàn)金”之前。-2、附表項目的改動-新