问题描述:固定资产清单累计折旧合计数不等于总账累计折旧科目的合计数
问题分析:适用EAS861
固定资产对账是否对的平?
固定资产卡片列表各卡片累计折旧数据与清单各卡片累计折旧数据是否一致?
固定资产卡片固定资产科目、累计折旧科目、减值准备科目填写是否错误?
如果上述前端查询都无问题,可以在查询分析器中执行下述语句
---查当前期间有差异的卡片---
select car.Faccudepr,ban.FDepreEndBalanceFor,car.fnumber
from t_fa_facurcard car
left join t_fa_faaccountbalance ban on ban.Ffacurcardid = car.FID
where car.fcompanyid = (select fid from t_org_company where fnumber ='公司编码')
and ban.Fcompanyorgunitid = (select fid from t_org_company where fnumber ='公司编码')
and ban.fperiodid in (select fid from t_bd_period where fnumber =会计期间编码)
and car.Faccudepr <>ban.FDepreEndBalanceFor
and ban.FDepreEndBalanceFor<>0
在上述结果中找一张最近两到三年内还在提折旧的卡片,然后去查固定资产折旧表折旧期是否连续,路径是:【财务会计】-【固定资产】-【报表统计】-【固定资产折旧表】,一般可能存在折旧跳期,如下图所示:
如果是上述情况,可以使用数据修复工具+修复语句进行数据修复,方法如下:
1.数据修复工具,执行下述两项
2.用下述修复语句修复卡片的净值、净额
update t_fa_Facurcard set fneatvalue = fassetvalue - faccudepr , fneatamt = fassetvalue - faccudepr - fdecvalue
where fcompanyid = (select fid from t_org_company where fnumber ='组织编码')
update t_fa_Famoncard set fneatvalue = fassetvalue - faccudepr , fneatamt = fassetvalue - faccudepr - fdecvalue
where fcompanyid = (select fid from t_org_company where fnumber ='组织编码')
update t_fa_Fabakcard set fneatvalue = fassetvalue - faccudepr , fneatamt = fassetvalue - faccudepr - fdecvalue
where fcompanyid = (select fid from t_org_company where fnumber ='组织编码')
update t_fa_Fabizcard set fneatvalue = fassetvalue - faccudepr , fneatamt = fassetvalue - faccudepr - fdecvalue
where fcompanyid = (select fid from t_org_company where fnumber ='组织编码')
推荐阅读