文档介绍：科目余额表中部分客户显示两行数据记录问题描述科目余额表过滤本期,科目选择‘应收账款’,显示核算项目, 报表显示有部分客户显示两行数据, 正确数据为这两行数据之和问题原因这种情况一般是由于核算项目横表中被凭证表、余额表引用的核算项目组合有重复记录导致解决思路或方法备份账套后请参考如下方法处理: Use AIS2009###### -- (指问题账套的账套号) 第一,创建临时表 t_itemdetail_error ,把重复核算项目记录插入该表 select a.*, Fdetailid_temp into t_itemdetail_error from t_itemdetail a join t_itemdetail b on = and = where =1 and <> and >0 order by 第二,在临时表 t_itemdetail_error 中修改错误的 fdetailid 值(以最小的 fdetailid 值为基准) update b set = from t_itemdetail_error a join t_itemdetail_error b on = and = where =1 and < and >0 第三,创建余额表临时表 t_balance_temp select * into t_balance_temp from t_balance order by fyear,fperiod,ountid,fdetailid,fcurrencyid 第四,更新余额表临时表的错误 detailid 值 update a set = from t_balance_temp a join t_itemdetail_error b on = 第五,创建临时表 temp002 select top 0* into temp002 from t_balance 第六,合并 t_balance_temp 相同核算项目项的金额,把结果插入 temp002 insert into temp002 (fyear,fperiod,ountid,fdetailid,fcurrencyid,FFrameWorkI D, FBeginBalanceFor,FDebitFor,FCreditFor,FYtdDebitFor,FYtdCred itFo r,FEndBalanceFor, FBeginBalance,FDebit,FCredit,FYtdDebit,FYtdCredit,FEndBalan ce) select fyear,fperiod,ountid,fdetailid,fcurrencyid,FFrameWorkID, sum(FBeginBalanceFo