内部轮训
固定资产计提折旧案例分析
数据处理初级标准课程（五）
分析问题总体思路和步骤
• 定位问题发生在哪个数据表 • 找出问题的根本原因 • 找出问题的解决方法
案例一
10.1固定资产折旧：客户在6月份变动了一下厂家，之后7月 份累计折旧一下子大了四万多块钱，经查发现1-6月份有部分 固定资产没有计提折旧,帐套（fatest20050908.rar)
找出问题的根本原因
delete from t_fadept insert into t_fadept select distinct a.falterid,d.fitemclsid,d.fitemid,d.frate from t_fabalance b inner join t_fabaldept d on b.fbalid=d.fbalid inner join t_faalter a on a.fassetid= b.fassetid order by falterid delete from t_faexpense insert into t_faexpense select distinct a.falterid,d.facctid,d.fdetailid,d.frate,d.fdeptid from t_fabalance b inner join t_fabalexpense d on b.fbalid=d.fbalid inner join t_faalter a on a.fassetid= b.fassetid
反结帐到卡片初始化期间
select * into t_fabal_hetemp from t_fabalance where fyear<>0 delete from t_FABalCardItem where fbalid in (select fbalid from t_fabal_hetemp ) delete from t_FABalCard where fbalid in (select fbalid from t_fabal_hetemp ) delete from t_FABaldevice where fbalid in (select fbalid from t_fabal_hetemp ) delete from t_FABalorgfor where fbalid in (select fbalid from t_fabal_hetemp ) delete from t_FABaldept where fbalid in (select fbalid from t_fabal_hetemp ) delete from t_FABalexpense where fbalid in (select fbalid from t_fabal_hetemp ) delete from t_fabalance where fbalid in (select fbalid from t_fabal_hetemp ) update t_systemprofile set fvalue=0 where fcategory=‘fa’ and fkey=‘closed‘—初始化 update t_systemprofile set fvalue=1 where fcategory='fa' and fkey='currentperiod'--初始化
