【原因分析】

原因：t_Balance表第1期数据异常

【解决方案】

可参考以下脚本执行处理：

declare @startyear int,@startperiod int

select @startyear=convert(int,FValue) from t_SystemProfile where FCategory='gl' and FKey='startyear'

select @startperiod=convert(int,FValue) from t_SystemProfile where FCategory='gl' and FKey='startperiod'

select * into #t_balancebak from t_balance

delete from t_balance where fperiod=1 and fyear=@startyear

alter table t_balance NOCHECK CONSTRAINT chk_balance

insert into t_balance

select @startyear as fyear ,1 as fperiod,FAccountID,FDetailID,FCurrencyID,

0 as FBeginBalanceFor, 0 as FDebitFor,0 as FCreditFor,FYtdDebitFor-FDebitFor,FYtdCreditFor-FCreditFor, FBeginBalanceFor as FEndBalanceFor,

0 as FBeginBalance,0 as FDebit, 0 as FCredit,FYtdDebit-FDebit,FYtdCredit-FCredit, FBeginBalance as FEndBalance,FFrameWorkID

from #t_balancebak where fperiod=@startperiod and fyear=@startyear

update t_balance set FDebitFor=FYtdDebitFor,FCreditFor=FYtdCreditFor,FDebit=FYtdDebit,FCredit=FYtdCredit

,FBeginBalanceFor =FEndBalanceFor-(FYtdDebitFor-FYtdCreditFor),FBeginBalance =FEndBalance-(FYtdDebit-FYtdCredit)

where fyear=@startyear and fperiod=1

alter table t_balance CHECK CONSTRAINT chk_balance

drop table #t_balancebak

go

正式账套执行脚本前请先做好备份，建议待在测试账套中核实无误后再在正式账套中执行。