-----在源帐套中执行

select * into aaa from (
select b.fnumber,b.fdc,a.faccountid,a.fcurrencyid,a.fdetailid,a.ftransno,a.ftransdate,a.fbeginbalancefor as famountfor,
       a.fbeginbalance as famount,fbeginqty as fquantity
from t_transinitbalance a join t_account b on a.faccountid=b.faccountid
where a.fcurrencyid<>0 and b.fcontact=1
union
select c.fnumber,c.fdc,b.faccountid,b.fcurrencyid,b.fdetailid,isnull(b.ftransno,'') as ftransno,a.fdate,
       case when b.fdc=0 then -b.famountfor else b.famountfor end as famountfor,
       case when b.fdc=0 then -b.famount else b.famount end as famount,
       case when b.fdc=0 then -b.fquantity else b.fquantity end as fquantity
from t_voucher a join t_voucherentry b on a.fvoucherid=b.fvoucherid join t_account c on b.faccountid=c.faccountid
where c.fcontact=1 ) tmp

select a.*,b.ftransdate into bbb from
(select faccountid,fcurrencyid,fdetailid,ftransno,sum(famountfor) as famountfor,sum(famount) as famount,sum(fquantity) as fquantity
from aaa group by faccountid,fcurrencyid,fdetailid,ftransno) a
left join (select faccountid,fcurrencyid,fdetailid,ftransno,max(ftransdate) as ftransdate
from aaa group by faccountid,fcurrencyid,fdetailid,ftransno)
 b on a.faccountid=b.faccountid and a.fdetailid=b.fdetailid and a.ftransno=b.ftransno

delete from bbb where famountfor=0 and famount=0

drop table aaa
drop table bbb