用友T6-企业管理软件5.1 固定资产模块的账表5月份总账和明细账对不上

问题回复：

请执行以下脚本 

UPDATE FA_total set dblmonthvalue=(select A.DBLVALUE from fa_total a where A.iperiod=4 and a.sdeptnum=b.sdeptnum and a.stypenum=b.stypenum) from fa_total b where iperiod=5 update fa_total set dblAddValue= ( select sum(dblvalue) from fa_cards where scardnum>='09107' and fa_cards.sdeptnum=fa_total.sdeptnum and fa_cards.stypenum=fa_total.stypenum group by sdeptnum,stypenum ) where iperiod=5 update fa_total set dblvalue=isnull(dblmonthvalue,0)+isnull(dbladdvalue,0) where iperiod=5