T6-企业管理软件5.1 固定资产总账和明细账对不上

固定资产总账和明细账对不上。

问题回复：

请做好账套备份，在2015账套库中执行如下脚本，对表fa_total重算后固定资产总账金额正确。 

update c set c.dblAddValue=d.zq from fa_total c join ( select a.dbl as cw,b.dbl as zq,a.sdeptnum,a.stypenum from (select dblAddValue as dbl,* from fa_total where iperiod=4 and dblAddValue<>0 ) a join (select sdeptnum,stypenum,sum(dblvalue)as dbl from fa_cards where scardnum>='09010' group by sdeptnum,stypenum )b on a.sdeptnum=b.sdeptnum and a.stypenum=b.stypenum where a.dbl<>b.dbl)d on c.sdeptnum=d.sdeptnum and c.stypenum=d.stypenum