专业版T型账户借贷方取数和科目余额表借贷方取数不一致，导致现金流量表期末数据取数异常

以上方案例为例，先找到出现问题的时间范围，再执行以下语句处理；

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

其中方案一不能修复T型账户借贷方合计问题，但可解决现金流量表取数问题，若需要两个问题同时解决建议采用方案二

方案一：
--创建存储过程
if  object_id('cashamountcheck') is not null   drop procedure cashamountcheck
go
create procedure cashamountcheck
 @startdate datetime,
 @enddate datetime
 as
 begin
select @enddate=dateadd(DD,1,@enddate)

select cc.FYear,cc.FPeriod,dd.FName,cc.FNumber,aa.FAmount 余额表发生额,bb.FAmount 流量表发生额
from
(select  a.FVoucherID, SUM((case b.FDC when 1 then 1 else -1 end)*b.FAmount)  FAmount
from t_Voucher a
join  t_VoucherEntry b on a.FVoucherID=b.FVoucherID
 join t_Account c on b.FAccountID=c.FAccountID and c.FAccountID in
(select FAccountID from t_Account where (FIsCash=1 or FIsBank=1 or FIsCashFlow=1) and FDetail=1)
where a.FDate>=@startdate and a.FDate<@enddate
group by a.FVoucherID) aa full join
(Select  t.FVoucherID, sum((case when i.fnumber like '%.01' then 1 else -1 end) *t.FAmount) FAmount
                 From t_Item i, (Select v.FVoucherID,i.Fnumber,Sum(b.FAmountFor) FAmountFor,Sum(b.FAmount) FAmount
                                 from t_CashFlowBal b
                                 inner join t_VoucherEntry e on e.FVoucherID=b.FVoucherID and e.FEntryID=b.FEntryID
                                 inner join t_Item i on b.FItemID=i.FItemID
                                 inner join (Select
                                             FBrNo,FvoucherID,FDate,FYear,FPeriod,
                                             FGroupID,FNumber,FReference,FExplanation,FAttachments,
                                             FEntryCount,FDebitTotal,FCreditTotal,FInternalInd,FChecked,
                                             FPosted,FPreparerID,FCheckerID,FPosterID,