文档介绍：用友U8各版本如果出现固定资产模块账表查询时数据有误,但是卡片管理中数据正确的情况下,在查询分析器中执行下述语句,注意下面红字部分,需要逐月修改执行。beginTRANSACTIONkk--创建临时表CREATETABLE#fq([sCardID]int,PRIMARYkeynonCLUSTERED([sCardID]))commitTRANSACTIONkk--初始化定义变量******@Begindatetime,***@enddatetime,***@iperiodint,***@acc_idvarchar(10),***@acc_yearvarchar(10)******@SQLnchar(2000)--得到当前本数据库的有关信息******@acc_id=substring(db_name(),8,3),***@acc_year=substring(db_name(),12,4),***@iperiod=3-----修改成需要重算总账的会计月份---******@Begin=[dBegin],***@end=[dEnd]FROM[UFSystem].[dbo].[UA_Period]where[_Id]=***@acc_idand[iYear]=***@acc_yearandiId=***@iperiod--******@acc_id,***@acc_year,***@iperiod,***@Begin,***@end--取月初有效卡片序号数据,计算月初累计折旧数据******@iperiod>12returninsert#fqSELECTmax(C.[sCardID])FROM[fa_Cards]CWHERE((<***@Begin)AND(<***@)AND(<***@))groupbyC.[sCardNum]--******@SQL=updatefa_totalsetdblMonthDeprTotal=isnull(DT,0),dblMonthvalue=isnull(Dv,0)FROMfa_totalTleftjoin(SelectD.[sDeptNum],C.[sTypeNum],sum(D.[dblValue])DV,sum(******@iperiod-1when0then[dblDeprT1]-[dblDepr1]when1then[dblDeprT1]when2then[dblDeprT2]when3then[dblDeprT3]when4then[dblDeprT4]when5then[dblDeprT5]when6then[dblDeprT6]when7then[dblDeprT7]when8then[dblDeprT8]when9then[dblDeprT9]when10then[dblDeprT10]when11then[dblDeprT11]else0end)DTfrom[fa_Cards]CJOIN[fa_Cards_Detail]DOND.[sCardID]=C.[sCardID]JOIN[fa_DeprTransactions_Detail]PONC.[sCardNum]=P.[sCardNum]ANDD.[sDeptNum]=P.[sDept