会计科目余额表中同一会计科目呈现多条记载表象如下：

问题描述:会计科目余额表中过滤本期,科目选择‘其他应收款’,勾选显示核算项目,点击确定。 查询出的报表中显示有部分客户显示两行数据,正确数据为这两行数据之和。  

问题分析:这种情况的出现一般是由于核算项目横表中被凭证表，余额表引用的核算项目组合有重复记录                   

解决方法：

1、合并t_balance_temp 相同核算项目项的金额，把结果插入temp002： 
           insert into temp002                (fyear,fperiod,faccountid,fdetailid,fcurrencyid, 
      FFrameWorkID,FBeginBalanceFor,FDebitFor,FCreditFor,FYtdDebitFor,       FYtdCreditFor,FEndBalanceFor, 
      FBeginBalance,FDebit,FCredit,FYtdDebit,FYtdCredit,FEndBalance)  
      Select fyear,fperiod,faccountid,fdetailid,fcurrencyid, 
      FFrameWorkID,sum(FBeginBalanceFor)FBeginBalanceFor, 
      sum(FDebitFor)FDebitFor,sum(FCreditFor)FCreditFor, 
      sum(FYtdDebitFor)FYtdDebitFor,sum(FYtdCreditFor)FYtdCreditFor, 
      sum(FEndBalanceFor)FEndBalanceFor,sum(FBeginBalance)FBeginBalance, 
      sum(FDebit)FDebit,sum(FCredit)FCredit,sum(FYtdDebit)FYtdDebit, 
      sum(FYtdCredit)FYtdCredit,sum(FEndBalance)FEndBalance  
      from t_balance_temp  
      group by       fyear,fperiod,faccountid,fdetailid,fcurrencyid,FFrameWorkID  
2、清空t_balance数据 : delete from t_balance  
3、把temp002的值写回t_balance: 
      insert into t_balance (fyear,fperiod,faccountid,fdetailid,fcurrencyid,
      FBeginBalanceFor,FDebitFor,FCreditFor,FYtdDebitFor, 
  FYtdCreditFor,FEndBalanceFor,FBeginBalance,FDebit,FCredit,FYtdDebit,       FYtdCredit,FEndBalance,FFrameWorkID)  
      Select       fyear,fperiod,faccountid,fdetailid,fcurrencyid,FBeginBalanceFor,
      FDebitFor,FCreditFor,FYtdDebitFor, 
  FYtdCreditFor,FEndBalanceFor,FBeginBalance,FDebit,FCredit,FYtdDebit,       FYtdCredit,FEndBalance,FFrameWorkID from temp002  
4、删除t_itemdetail中的重复值： 
      delete  from  t_itemdetail  where  fdetailid  in  (select  fdetailid  from 
      t_itemdetail_error)  and  fdetailid  not  in  (select  fdetailid_temp  from  t_itemdetail_error)  
5、更新纵表： exec sp_cleanitemdetailv  
6、更正凭证分录数据：  
      update a set a.fdetailid=b.fdetailid_temp from t_voucherentry a        join t_itemdetail_error b on a.fdetailid=b.fdetailid  
      where a.fdetailid<>b.fdetailid_temp  
南通金蝶kis/南通金蝶财务软件