金蝶错误修复方法

C:\Windows\System32\Netplwiz.exe
C:\Windows\System32\netsh.exe

金蝶错误解决
1、----------------------------------------------------------------------------------------------------------------------------------
错误代码:3639(E37H)
Source :Microsoft OLE DB Provider for SQL Server
Detail :对象名 't_FADeprPolicy' 无效。
或-----------------------------------------------------------------------------------------------------------------------------------
打开科目时，只显示资产和负债两个类别，提示：类型不匹配
错误代码:13(DH)
Source :SystemDataLib

成功的解决方法：
IF NOT EXISTS (SELECT * FROM SYSOBJECTS WHERE ID = OBJECT_ID(N'[t_FADeprPolicy]') and OBJECTPROPERTY(id, N'IsUserTable') = 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 (0),
[FAlterDeprPolicy] [smallint] NOT NULL DEFAULT (0),
[FClearDeprPolicy] [smallint] NOT NULL DEFAULT (0),
[FDefault] [smallint] NOT NULL DEFAULT (0)
) ON [PRIMARY]
END

IF NOT EXISTS(SELECT 1 FROM sysobjects o, syscolumns c where o.id=c.id and https://www.sodocs.net/doc/0418059181.html,='t_FaCard' and https://www.sodocs.net/doc/0418059181.html,='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 and https://www.sodocs.net/doc/0418059181.html,='t_fabalcard' and https://www.sodocs.net/doc/0418059181.html,='FCurrentEffect')
alter table t_fabalcard add FCurrentEffect [smallint] NOT NULL DEFAULT (0)
IF EXISTS (SELECT * FROM SYSOBJECTS WHERE ID = OBJECT_ID(N'[vw_fa_card]') and OBJECTPROPERTY(id, N'IsView') = 1)
Begin
Drop View vw_fa_card
End
GO
CREATE 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,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.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,
am.FNumber as FAlterModeNumber,am.FName as FAlterModeName,
sta.FNumber as FStatusNumber,sta.FName as FStatusName,
dm.FName as FDeprMethodName,
act1.FNumber as FAssetAcct

Number,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_FAEconomyUse 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
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_DataFlowDetailFunc where FDetailFuncID = 30106
INSERT 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 FROM 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,1
IF EXISTS(SELECT 1 FROM sysobjects o, syscolumns c where o.id=c.id and https://www.sodocs.net/doc/0418059181.html,='t_FaCard' and https://www.sodocs.net/doc/0418059181.html,='FDeprPolicyID')
UPDATE [t_FaCard] SET FDeprPolicyID=1 WHERE FDeprPolicyID IS Null
GO
Delete from t_LogFunction WHERE FFunctionID = 'C00208'
InSert INTO t_LogFunction(FFunctionID,FSubSysID,FFunctionName,FFunctionName_CHT,FFunctionName_EN)
Values('C00208',3,'固定资产基础资料--折旧政策管理','固定資產基礎資料—折舊政策管理','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 FFuncID=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,FDescription_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_FADep

rPolicy] WITH NOCHECK ADD
CONSTRAINT [pk_t_FADeprPolicy] PRIMARY KEY CLUSTERED
(
[FID]
) ON [PRIMARY]
GO
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

2、固定资产卡片做清理，保存时出现错误提示：可能由于网络问题，卡片保存失败，请重新保存！
错误代码: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(N'[t_FADeprPolicy]') and OBJECTPROPERTY(id, N'IsUserTable') = 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] 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：非默认的折旧政策方案
) 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 https://www.sodocs.net/doc/0418059181.html,='t_FaCard' and https://www.sodocs.net/doc/0418059181.html,='FDeprPolicyID')
Alter TABLE [t_FaCard] Add FDeprPolicyID [int] NOT NULL DEFAULT (1)


--Add By Wedison K3V10.4,卡片每期信息表 增加【折旧政策是否影响当期折旧的字段】 2006-08-01
IF NOT EXISTS(SELECT 1 FROM sysobjects o, syscolumns c where o.id=c.id and https://www.sodocs.net/doc/0418059181.html,='t_fabalcard' and https://www.sodocs.net/doc/0418059181.html,='FCurrentEffect')
alter table t_fabalcard add FCurrentEffect [smallint] NOT NULL DEFAULT (0) --0:当期变动下期生效,当期新增下期折旧，其他:当期变动当期生效,当期新增当期折旧


--10.4 增加折旧政策信息字段
IF EXISTS (SELECT * FROM SYSOBJECTS WHERE ID = OBJECT_ID(N'[vw_fa_card]') and OBJECTPROPERTY(id, N'IsView') = 1)
Begin
Drop View vw_fa_card
End

GO

CREATE VIE

W 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,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.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,
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 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_FAEconomyUse 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
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_DataFlowDetailFunc where FDetailFuncID = 30106
INSERT 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,'','','')
--主控台


--Begin t_FADeprPolicy 折旧政策预设数据
IF EXISTS( SELECT 1 FROM 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,1
--End t_FADeprPolicy 折旧政策预设数据

IF EXISTS(SELECT 1 FROM sysobjects o, syscolumns c where o.id=c.id and https://www.sodocs.net/doc/0418059181.html,='t_FaCard' and https://www.sodocs.net/doc/0418059181.html,='FDeprPolicyID')
UPDATE

[t_FaCard] SET FDeprPolicyID=1 WHERE FDeprPolicyID IS Null
GO

--固定资产折旧政策权限使用固定资产基础资料的权限（FObjectType=30 and FObjectID = 1）类似变动方式的权限



--折旧政策 日志
Delete from t_LogFunction WHERE FFunctionID = 'C00208'
InSert INTO t_LogFunction(FFunctionID,FSubSysID,FFunctionName,FFunctionName_CHT,FFunctionName_EN)
Values('C00208',3,'固定资产基础资料--折旧政策管理','固定資產基礎資料—折舊政策管理','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 FFuncID=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,FDescription_cht,FDescription_en)
VALUES (2123,'FA120',3,'删除折旧政策方案','刪除折舊政策方案','')

--折旧政策管理 网络控制




--最后执行
UPDATE t_DataFlowTimeStamp SET FName = FName

--Begin t_FADeprPolicy 记折旧政策表的主键索引 *
/************************************************************************/
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 [PRIMARY]
GO
--End t_FADeprPolicy 记折旧政策表的主键索引

--Total,PRJ00044685,取消计价方法－后进先出法,当没有物料的时候，新建账套。
IF NOT EXISTS (SELECT TOP 1 FTrack FROM t_ICItem WHERE FTrack=79)
DELETE FROM t_SubMessage WHERE FtypeID=200 and FID='F004'
GO

--增加共同科目类别
IF NOT EXISTS (SELECT 1 FROM t_AcctGroup WHERE FClassID=7)
BEGIN
INSERT INTO t_AcctGroup(FClassID,FGroupID,FName,FName_Cht,FName_En) Values (7,0,'共同','共同','Together')
INSERT INTO t_AcctGroup(FClassID,FGroupID,FName,FName_Cht,FName_En) Values (7,700,'共同','共同','Together')
END
GO

--ADD BY YOKI FOR GL012现金流量表项目的调整 2006-09-20
--通过以下判断，控制仅在新建帐套或未使用过现金流量表的帐套中增加项目
IF (NOT EXISTS(SELECT top 1 * FROM 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)=54
BEGIN
--1、主表项目的改动:
DECLARE @ItemID INT
--修改类别：＂投资活动产生的现金流量－现金流入

＂
IF NOT EXISTS (SELECT 1 FROM t_Item WHERE FNumber='CI2.01.05' AND FItemClassID=9)
BEGIN
--将“CI2.01.04收到的其它与投资活动有关的现金”流量项目代码修改为“CI2.01.05”
UPDATE t_Item SET FNumber='CI2.01.05',FShortNumber='05',FFullNumber='CI2.01.05' WHERE FNumber='CI2.01.04' AND FItemCLassID=9
SELECT @ItemID=FItemID FROM t_Item WHERE FNumber='CI2.01' AND FItemCLassID=9

--并新增“CI2.01.04购买或处置子公司及其他营业单位产生的现金净额”。
INSERT INTO t_Item(FItemClassID, FNumber,FParentID,FLevel,FDetail,FName,FFullNumber,FShortNumber)
VALUES (9,'CI2.01.04',@ItemID,3,1,'购买或处置子公司及其他营业单位产生的现金净额','CI2.01.04','04')
END
--修改类别：＂投资活动产生的现金流量－现金流出＂
IF NOT EXISTS (SELECT 1 FROM t_Item WHERE FNumber='CI2.02.04' AND FItemClassID=9)
BEGIN
--将“CI2.02.03支付的其它与投资活动有关的现金”流量项目代码修改为“CI2.02.04”
UPDATE t_Item SET FNumber='CI2.02.04',FShortNumber='04',FFullNumber='CI2.02.04' WHERE FNumber='CI2.02.03' AND FItemCLassID=9
SELECT @ItemID=FItemID FROM t_Item WHERE FNumber='CI2.02' AND FItemCLassID=9

--新增现金流量项目：“CI2.01.03-取得子公司及其他营业单位支付的现金净额”。
INSERT INTO t_Item(FItemClassID, FNumber,FParentID,FLevel,FDetail,FName,FFullNumber,FShortNumber)
VALUES (9,'CI2.02.03',@ItemID,3,1,'取得子公司及其他营业单位支付的现金净额','CI2.02.03','03')
END
--2、附表项目的改动
IF NOT EXISTS (SELECT 1 FROM t_Item WHERE FNumber='CI5.01.17' AND FItemClassID=9)
BEGIN
--将系统原CI5.01.10至CI5.01.16流量项目代码均往后顺延1。即：CI5.01.10改为CI5.01.11，CI5.01.11改为CI5.01.12……
UPDATE t_Item SET FNumber='CI5.01.17',FShortNumber='17',FFullNumber='CI5.01.17' WHERE FNumber='CI5.01.16' AND FItemCLassID=9
UPDATE t_Item SET FNumber='CI5.01.16',FShortNumber='16',FFullNumber='CI5.01.16' WHERE FNumber='CI5.01.15' AND FItemCLassID=9
UPDATE t_Item SET FNumber='CI5.01.15',FShortNumber='15',FFullNumber='CI5.01.15' WHERE FNumber='CI5.01.14' AND FItemCLassID=9
UPDATE t_Item SET FNumber='CI5.01.14',FShortNumber='14',FFullNumber='CI5.01.14' WHERE FNumber='CI5.01.13' AND FItemCLassID=9
UPDATE t_Item SET FNumber='CI5.01.13',FShortNumber='13',FFullNumber='CI5.01.13' WHERE FNumber='CI5.01.12' AND FItemCLassID=9
UPDATE t_Item SET FNumber='CI5.01.12',FShortNumber='12',FFullNumber='CI5.01.12' WHERE FNumber='CI5.01.11' AND FItemCLassID=9
UPDATE t_Item SET FNumber='CI5.01.11',FShortNumber='11',FFullNumber='CI5.01.11' WHERE FNumber='CI5.01.10' AND FItemCLassID=9
--并新增流量项目：“CI5.01.10公允价值变动损益”
SELECT @ItemID=FItemID FROM t_Item WHERE FNumber='CI5.01' AND FItemCLassID=9
INSERT INTO t_Item(FItemClassID, FNumber,FParentID,FLevel,FDetail,FName,FFullNumber,FShortNumber)
VALUES (9,'CI5.01.10',

@ItemID,3,1,'公允价值变动损益','CI5.01.10','10')
END
END
GO
--ADD BY YOKI FOR CF012老的现金流量表系统中流量项目的调整 2006-10-10
--1、主表项目的改动:
--修改类别：＂投资活动产生的现金流量－现金流入＂
--新增“处置子公司及其他营业单位收到的现金净额”,放在“收到的其它与投资活动有关的现金”之前
--修改类别：＂投资活动产生的现金流量－现金流出＂
--新增现金流量项目：“取得子公司及其他营业单位支付的现金净额”,放在“支付的其它与投资活动有关的现金”之前。
--2、附表项目的改动
--新增流量项目：“公允价值变动损失”,放在"固定资产报废损失"与"财务费用"之间
IF NOT EXISTS(SELECT 1 FROM t_CFItem WHERE FParent=2 AND FIndex=2104 AND FCaption='处置子公司及其他营业单位收到的现金净额')
AND NOT EXISTS(SELECT 1 FROM t_CFItem WHERE FParent=2 AND FIndex=2203 AND FCaption='取得子公司及其他营业单位支付的现金净额')
AND NOT EXISTS(SELECT 1 FROM t_CFItem WHERE FParent=7 AND FIndex=6110 AND FCaption='公允价值变动损失')
BEGIN
UPDATE t_CFItem SET FIndex=FIndex+1 WHERE FIndex>2103 and FIndex<2198
INSERT INTO T_CFItem (FCaption, FIndex, FSpecial, FCashIn, FDebitValue, FCreditValue, FParent, FMiddle, FFirstID, FFirstPercent, FSecondID, FSecondPercent, FThirdID, FThirdPercent, FAppend, FIsSumItem, FManual)
VALUES ('处置子公司及其他营业单位收到的现金净额',2104,0,1,0,0,2,0,0,0,0,0,0,0,0,0,0)


UPDATE t_CFItem SET FIndex=FIndex+1 WHERE FIndex>2202 and FIndex<2298
INSERT INTO T_CFItem (FCaption, FIndex, FSpecial, FCashIn, FDebitValue, FCreditValue, FParent, FMiddle, FFirstID, FFirstPercent, FSecondID, FSecondPercent, FThirdID, FThirdPercent, FAppend, FIsSumItem, FManual)
VALUES ('取得子公司及其他营业单位支付的现金净额',2203,0,0,0,0,2,0,0,0,0,0,0,0,0,0,0)

UPDATE t_CFItem SET FIndex=FIndex+1 WHERE FIndex>6109 and FIndex<6198
INSERT INTO T_CFItem (FCaption, FIndex, FSpecial, FCashIn, FDebitValue, FCreditValue, FParent, FMiddle, FFirstID, FFirstPercent, FSecondID, FSecondPercent, FThirdID, FThirdPercent, FAppend, FIsSumItem, FManual)
VALUES ('公允价值变动损失',6110,0,0,0,0,26,0,0,0,0,0,0,0,1,0,0)
END
GO
--END
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------

4、报表模块为空的解决方法：
--报表系统增加模板
DELETE t_Rpt_PropItem WHERE FName ='新企业会计准则'
GO
INSERT INTO t_Rpt_PropItem(FPropClsID,FPropItemID,FNumber,FName,FName_Cht,FName_EN)
VALUES (1001,124,'124','新企业会计准则','新企業會計準則','New Accounting Standard')
go
Delete FROM t_DataFlowSubFunc Where FSubFuncID=728
INSERT INTO t_DataFlowSubFunc(FSubFuncID,FSubSysID,FIndex,FFuncName,FFuncName_CHT,FFuncName_EN,FCla

ssName,FClassParam,FVisible,FAcctType,FFuncType,FRefresh,FSetEnable,FSubID) VALUES(728,7,28,'(行业)-新企业会计准则','(行業)-新企業會計準則','(Industry)-New Accounting Standard','EbcglView.GLData','',1,'',0,1,0,'')
GO
Delete From t_Rpt_Content WHERE FRptName ='新会计准则利润表'
GO
InsertFile t_Rpt_Content(FRptName,FRptName_Cht,FRptName_EN,FSysName,FYear,FPeriod,FOwner,FRptType,FRptData, F1001)
values('新会计准则利润表','新會計準則利潤表','', '报表系统', 2006, 9, 16394, 3, ,124)
GO
Delete From t_Rpt_Content WHERE FRptName ='新会计准则所有者权益（股东权益）变动表'
GO
InsertFile t_Rpt_Content(FRptName,FRptName_Cht,FRptName_EN,FSysName,FYear,FPeriod,FOwner,FRptType,FRptData, F1001)
values('新会计准则所有者权益（股东权益）变动表','新會計準則所有者權益（股東權益）變動表','', '报表系统', 2006, 9, 16394, 3, ,124)
GO
Delete From t_Rpt_Content WHERE FRptName ='新会计准则现金流量表'
GO
InsertFile t_Rpt_Content(FRptName,FRptName_Cht,FRptName_EN,FSysName,FYear,FPeriod,FOwner,FRptType,FRptData, F1001)
values('新会计准则现金流量表','新會計準則現金流量表','', '报表系统', 2006, 9, 16394, 3, ,124)
GO
Delete From t_Rpt_Content WHERE FRptName ='新会计准则资产负债表'
GO
InsertFile t_Rpt_Content(FRptName,FRptName_Cht,FRptName_EN,FSysName,FYear,FPeriod,FOwner,FRptType,FRptData, F1001)
values('新会计准则资产负债表','新會計準則資產負債表','','报表系统', 2006, 9, 16394, 3, ,124)
go