金蝶错误修复方法.docx
《金蝶错误修复方法.docx》由会员分享,可在线阅读,更多相关《金蝶错误修复方法.docx(20页珍藏版)》请在冰点文库上搜索。
![金蝶错误修复方法.docx](https://file1.bingdoc.com/fileroot1/2023-5/18/56a08bab-1ec9-42a6-9043-bf87bd28a315/56a08bab-1ec9-42a6-9043-bf87bd28a3151.gif)
金蝶错误修复方法
金蝶错误修复方法
C:
\Windows\System32\Netplwiz.exe
C:
\Windows\System32\netsh.exe
金蝶错误解决
1、----------------------------------------------------------------------------------------------------------------------------------
错误代码:
3639(E37H)
Source:
MicrosoftOLEDBProviderforSQLServer
Detail:
对象名't_FADeprPolicy'无效。
或-----------------------------------------------------------------------------------------------------------------------------------
打开科目时,只显示资产和负债两个类别,提示:
类型不匹配
错误代码:
13(DH)
Source:
SystemDataLib
成功的解决方法:
IFNOTEXISTS(SELECT*FROMSYSOBJECTSWHEREID=OBJECT_ID(N'[t_FADeprPolicy]')andOBJECTPROPERTY(id,N'IsUserTable')=1)
BEGIN
CREATETABLE[t_FADeprPolicy]
(
[FID][int]IDENTITY(1,1),
[FNumber][nvarchar](80)NOTNULL,
[FName][nvarchar](80)NOTNULL,
[FLevel][int]NOTNULL,
[FParentId][int]NOTNULL,
[FDetail][smallint]NOTNULL,
[FAddDeprPolicy][smallint]NOTNULLDEFAULT(0),
[FAlterDeprPolicy][smallint]NOTNULLDEFAULT(0),
[FClearDeprPolicy][smallint]NOTNULLDEFAULT(0),
[FDefault][smallint]NOTNULLDEFAULT(0)
)ON[PRIMARY]
END
IFNOTEXISTS(SELECT1FROMsysobjectso,syscolumnscwhereo.id=c.idando.name='t_FaCard'andc.Name='FDeprPolicyID')
AlterTABLE[t_FaCard]AddFDeprPolicyID[int]NOTNULLDEFAULT
(1)
IFNOTEXISTS(SELECT1FROMsysobjectso,syscolumnscwhereo.id=c.idando.name='t_fabalcard'andc.Name='FCurrentEffect')
altertablet_fabalcardaddFCurrentEffect[smallint]NOTNULLDEFAULT(0)
IFEXISTS(SELECT*FROMSYSOBJECTSWHEREID=OBJECT_ID(N'[vw_fa_card]')andOBJECTPROPERTY(id,N'IsView')=1)
Begin
DropViewvw_fa_card
End
GO
CREATEVIEWvw_fa_cardAS
selectal.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,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,
card.FAdjustOldDepr,card.FEconomyUseID,card.FLocationID,card.FGroupID,
card.FAlterModeID,card.FStatusID,card.FDeprMethodID,card.FAssetAcctID,
card.FDeprAcctID,
policy.FIDasFDeprPolicyID,policy.FNameasFPolicyName,policy.FNumberasFPolicyNumber,
eu.FNumberasFEconomyUseNumber,eu.FNameasFEconomyUseName,
loc.FNumberasFLocationNumber,loc.FNameasFLocationName,
grp.FNumberasFGroupNumber,grp.FNameasFGroupName,
am.FNumberasFAlterModeNumber,am.FNameasFAlterModeName,
sta.FNumberasFStatusNumber,sta.FNameasFStatusName,
dm.FNameasFDeprMethodName,
act1.FNumberasFAssetAcctNumber,act1.FNameasFAssetAcctName,
act2.FNumberasFDeprAcctNumber,act2.FNameasFDeprAcctName,
isnull(vg.FName,'')asFVchGroupName
fromt_FAAlteral
leftjoint_FACardcardonal.FAlterID=card.FAlterID
leftjoint_FACardItemcional.FAlterID=ci.FAlterID
leftjoint_FAEconomyUseeuoncard.FEconomyUseID=eu.FID
leftjoint_FALocationloconcard.FLocationID=loc.FID
leftjoint_FAGroupgrponcard.FGroupID=grp.FID
leftjoint_FAAlterModeamoncard.FAlterModeID=am.FID
leftjoint_FAStatusstaoncard.FStatusID=sta.FID
leftjoint_FADeprMethoddmoncard.FDeprMethodID=dm.FID
leftjoint_Accountact1oncard.FAssetAcctID=act1.FAccountID
leftjoint_Accountact2oncard.FDeprAcctID=act2.FAccountID
leftjoint_VoucherGroupvgonam.FVchGroupID=vg.FGroupID
leftjoint_FADeprPolicypolicyoncard.FDeprPolicyID=policy.FID
whereci.FAMulAlterClassID=0
GO
deletefromt_DataFlowDetailFuncwhereFDetailFuncID=30106
INSERTINTOt_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,'','','')
IFEXISTS(SELECT1FROMt_FADeprPolicyWHEREFNumber='01')
DELETEFROMt_FADeprPolicyWHEREFNumber='01'
INSERTINTOt_FADeprPolicy(FNumber,FName,FLevel,FParentId,FDetail,FAddDeprPolicy,FAlterDeprPolicy,FClearDeprPolicy,FDefault)
SELECT'01','常用折旧政策',1,0,1,1,1,1,1
IFEXISTS(SELECT1FROMsysobjectso,syscolumnscwhereo.id=c.idando.name='t_FaCard'andc.Name='FDeprPolicyID')
UPDATE[t_FaCard]SETFDeprPolicyID=1WHEREFDeprPolicyIDISNull
GO
Deletefromt_LogFunctionWHEREFFunctionID='C00208'
InSertINTOt_LogFunction(FFunctionID,FSubSysID,FFunctionName,FFunctionName_CHT,FFunctionName_EN)
Values('C00208',3,'固定资产基础资料--折旧政策管理','固定資產基礎資料—折舊政策管理','FixedAssetsMasterData-ChangeDepreciationPolicy')
DELETEFROMt_SysFunctionWHEREFFuncID=2121ANDFSubSysID=3
INSERTINTOt_SysFunction(FFuncID,FNumber,FSubSysID,FDescription,FDescription_cht,FDescription_en)
VALUES(2121,'FA118',3,'增加折旧政策方案','增加折舊政策方案','')
DELETEFROMt_SysFunctionWHEREFFuncID=2122ANDFSubSysID=3
INSERTINTOt_SysFunction(FFuncID,FNumber,FSubSysID,FDescription,FDescription_cht,FDescription_en)
VALUES(2122,'FA119',3,'编辑折旧政策方案','編輯折舊政策方案','')
DELETEFROMt_SysFunctionWHEREFFuncID=2123ANDFSubSysID=3
INSERTINTOt_SysFunction(FFuncID,FNumber,FSubSysID,FDescription,FDescription_cht,FDescription_en)
VALUES(2123,'FA120',3,'删除折旧政策方案','刪除折舊政策方案','')
UPDATEt_DataFlowTimeStampSETFName=FName
IFNOTEXISTS(SELECT1FROMsysObjectsWHEREname='pk_t_FADeprPolicy')
ALTERTABLE[t_FADeprPolicy]WITHNOCHECKADD
CONSTRAINT[pk_t_FADeprPolicy]PRIMARYKEYCLUSTERED
(
[FID]
)ON[PRIMARY]
GO
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
2、固定资产卡片做清理,保存时出现错误提示:
可能由于网络问题,卡片保存失败,请重新保存!
错误代码:
1000(3E8H)
Source:
EBSFACard.Create
处理的方法:
use数据库名
updatedbo.t_FACardsetFDeprPolicyID=(selectFIDfromdbo.t_FADeprPolicy)
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
3、固定资产的新增中,折旧策略无法选择,会出错,解决方法:
--AddByWedisonK3V10.4,新增固定资产折旧政策表
IFNOTEXISTS(SELECT*FROMSYSOBJECTSWHEREID=OBJECT_ID(N'[t_FADeprPolicy]')andOBJECTPROPERTY(id,N'IsUserTable')=1)
BEGIN
CREATETABLE[t_FADeprPolicy]
(
[FID][int]IDENTITY(1,1),
[FNumber][nvarchar](80)NOTNULL,--编号
[FName][nvarchar](80)NOTNULL,--名称
[FLevel][int]NOTNULL,--级次
[FParentId][int]NOTNULL,--父级id
[FDetail][smallint]NOTNULL,--是否明细级
[FAddDeprPolicy][smallint]NOTNULLDEFAULT(0),--卡片新增的折旧政策,1:
当期新增当期计提折旧,0:
当期新增下期计提折旧
[FAlterDeprPolicy][smallint]NOTNULLDEFAULT(0),--卡片变动的折旧政策,1:
当期变动当期生效,0:
当期变动下期生效
[FClearDeprPolicy][smallint]NOTNULLDEFAULT(0),--卡片清理的折旧政策,1:
当期清理当期不再计提折旧,0:
当期清理当期仍然计提折旧
[FDefault][smallint]NOTNULLDEFAULT(0)--是否是默认的折旧政策方案,1:
默认的折旧政策方案,0:
非默认的折旧政策方案
)ON[PRIMARY]
END
--AddByWedisonK3V10.4,卡片信息表增加【折旧政策字段】2006-07-12
IFNOTEXISTS(SELECT1FROMsysobjectso,syscolumnscwhereo.id=c.idando.name='t_FaCard'andc.Name='FDeprPolicyID')
AlterTABLE[t_FaCard]AddFDeprPolicyID[int]NOTNULLDEFAULT
(1)
--AddByWedisonK3V10.4,卡片每期信息表增加【折旧政策是否影响当期折旧的字段】2006-08-01
IFNOTEXISTS(SELECT1FROMsysobjectso,syscolumnscwhereo.id=c.idando.name='t_fabalcard'andc.Name='FCurrentEffect')
altertablet_fabalcardaddFCurrentEffect[smallint]NOTNULLDEFAULT(0)--0:
当期变动下期生效,当期新增下期折旧,其他:
当期变动当期生效,当期新增当期折旧
--10.4增加折旧政策信息字段
IFEXISTS(SELECT*FROMSYSOBJECTSWHEREID=OBJECT_ID(N'[vw_fa_card]')andOBJECTPROPERTY(id,N'IsView')=1)
Begin
DropViewvw_fa_card
End
GO
CREATEVIEWvw_fa_cardAS
selectal.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,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,
card.FAdjustOldDepr,card.FEconomyUseID,card.FLocationID,card.FGroupID,
card.FAlterModeID,card.FStatusID,card.FDeprMethodID,card.FAssetAcctID,
card.FDeprAcctID,
policy.FIDasFDeprPolicyID,policy.FNameasFPolicyName,policy.FNumberasFPolicyNumber,
eu.FNumberasFEconomyUseNumber,eu.FNameasFEconomyUseName,
loc.FNumberasFLocationNumber,loc.FNameasFLocationName,
grp.FNumberasFGroupNumber,grp.FNameasFGroupName,
am.FNumberasFAlterModeNumber,am.FNameasFAlterModeName,
sta.FNumberasFStatusNumber,sta.FNameasFStatusName,
dm.FNameasFDeprMethodName,
act1.FNumberasFAssetAcctNumber,act1.FNameasFAssetAcctName,
act2.FNumberasFDeprAcctNumber,act2.FNameasFDeprAcctName,
isnull(vg.FName,'')asFVchGroupName
fromt_FAAlteral
leftjoint_FACardcardonal.FAlterID=card.FAlterID
leftjoint_FACardItemcional.FAlterID=ci.FAlterID
leftjoint_FAEconomyUseeuoncard.FEconomyUseID=eu.FID
leftjoint_FALocationloconcard.FLocationID=loc.FID
leftjoint_FAGroupgrponcard.FGroupID=grp.FID
leftjoint_FAAlterModeamoncard.FAlterModeID=am.FID
leftjoint_FAStatusstaoncard.FStatusID=sta.FID
leftjoint_FADeprMethoddmoncard.FDeprMethodID=dm.FID
leftjoint_Accountact1oncard.FAssetAcctID=act1.FAccountID
leftjoint_Accountact2oncard.FDeprAcctID=act2.FAccountID
leftjoint_VoucherGroupvgonam.FVchGroupID=vg.FGroupID
leftjoint_FADeprPolicypolicyoncard.FDeprPolicyID=policy.FID
whereci.FAMulAlterClassID=0
GO
--主控台
deletefromt_DataFlo