固定资产折旧专题初级Ⅴ

1、内部轮训固定资产计提折旧案例分析数据处理初级标准课程（五） 定位问题发生在哪个数据表 找出问题的根本原因 找出问题的解决方法分析问题总体思路和步骤10.1固定资产折旧：客户在6月份变动了一下厂家，之后7月份累计折旧一下子大了四万多块钱，经查发现1-6月份有部分固定资产没有计提折旧,帐套（fatest20050908.rar)案例一问题定位这种问题很明确，只需要比较数据，具体找一张卡片如999-228，在参与折旧用到的表进行数据比较，关键比较折旧方法，预计使用期间，已使用期间，原值，原值（累计折旧）科目等折旧要素select fdeprmethodid, flifeperiods,* from

2、t_facard where fassetnumber=999-228-424,968select fdeprmethodid,flifeperiods,* from t_fabalcard where fassetnumber=999-228-424,968select * from t_faalter where falterid in (424,968)-424select * from t_fabalance where fassetid=424找出问题的根本原因出现这种情况的卡片多，单张更新很麻烦，反到处世化修改找出问题的解决方法总原则：保证折旧方法，预计使用期间数据一致select

3、 * into t_fabal_hetemp from t_fabalance where fyear0delete 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_

4、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 )updat

5、e t_systemprofile set fvalue=0 where fcategory=fa and fkey=closed初始化update t_systemprofile set fvalue=1 where fcategory=fa and fkey=currentperiod-初始化案例二 （帐套：fatest0907.rar)10.2版本提示：固定资产在计提折旧时出现“科目没有权限,5(5H)的错误代码”提示 只要是科目没有权限，或核算项目无权限，则一定是t_fabalexpense,或t_faexpense中的facctid（fdetailid)对应的科目(核算项目）在科目表

6、（t_itemdetail)不存在或已禁用，或不是最明细问题定位找出问题的根本原因求证问题select * from t_faexpense where facctid=1070-无记录select * from t_fabalexpense where facctid=1070-643select * from t_account where faccountid=1070-无记录是否还有其它不存在的科目select distinct facctid from t_fabalexpense where facctid not in (select faccountid from t_acco

7、unt)找出问题的解决方法一种方法：替代一种方法：新增案例三： (帐套：seafood2004.rar）1.卡片计算折旧过程已成功，t_fabalance的fdepr已生成数据2.t_fabalexpense的famount数据与t_fabalance的fdepr不符一般是t_fabalexpense数据有问题，或缺少（多）记录，或同一卡片，折旧额不等（根本原因：frate错误）问题定位求证问题： 差6分钱select sum(famount) from t_fabalexpense where fbalid in (select fbalid from t_fabalance where f

8、period=8 and fyear=2005) -362850.4100select sum(fdepr)from t_fabalance where fperiod=8 and fyear=2005-362850.4700错误原因：丢记录吗？select distinct falterid from t_facard-468select distinct falterid from t_faexpense-468select * from t_faalter where fnew=1-402select * from t_faalter where fcleared=1-17 8月必须有3

9、85余额记录select fbalid from t_fabalance where fperiod=8 and fyear=2005-385select distinct fbalid from t_fabalexpense where fbalid in (select fbalid from t_fabalance where fperiod=8 and fyear=2005)385记录没有丢失找出问题的根本原因8月有卡片折旧额与费用分配不符select e.fbalid,e.famount,b.fdepr from (select fbalid,sum(famount) as famo

10、unt from t_fabalexpense where fbalid in (select fbalid from t_fabalance where fperiod=8 and fyear=2005) group by fbalid ) e,t_fabalance b where e.fbalid=b.fbalid and b.fperiod=8 and b.fyear=2005 and e.famountb.fdepr找出问题的根本原因找出问题的根本原因找出具体卡片找出问题的解决方法1.折旧管理中手工修改卡片折旧额，以t_fabalexpense为准，然后重新计提折旧，选择保留修改后的

11、折旧额案例四：卡片的入账折旧要素丢失问题定位select * from t_facard where fassetnumber=102002-falterid=2select * from t_faalter where falterid=2-fassetid=2select * from t_fabalance where fassetid=2Select * from t_faalter以卡片102002为切入点，查看卡片数据情况修改卡片日期及启用期间update t_systemprofile set fvalue=2005 where fcategory=fa and fkey=Sta

12、rtYearupdate t_systemprofile set fvalue=2005-01-01 where fcategory=fa and fkey=StartDate-2005-06-23update t_faalter set fdate=2005-07-05 where fperiod=7update t_faalter set fdate=2004-12-31 where fperiod=0update t_fabalance set fdate=2004-12-31,faltdate=2004-12-31 where faltdate2005-07-05update t_fa

13、balance set fdate=2005-07-05,faltdate=2005-07-05 where fassetid=1239update t_faalter set fnew=1-fnew,fcleaned,fotheralter必须有唯一值卡片是从别的帐套引入进来，卡片数据不完整，经过前面处理，还是解决不了问题对引入的卡片，出现问题，最好的解决方法是，回到初始化期间，在初始化进行数据调整select * from t_faalter -1239select * from t_facard-1239select * from t_fadept-259select * from t_

14、faexpense-270select * from t_facarditem1239查找丢失记录的表，然后补回数据找出问题的根本原因delete from t_fadeptinsert 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.fbalidinner join t_faalter a on a.fassetid= b.fassetid order by falteriddele

15、te from t_faexpenseinsert 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 fyear0delete

16、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_het

17、emp )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=

18、closed初始化update t_systemprofile set fvalue=1 where fcategory=fa and fkey=currentperiod-初始化反结帐到卡片初始化期间在初始化界面，修改卡片的部门和费用科目关闭初始化，然后重新计提折旧 案例五：v10.1,2005年1月启用,固定资产为从其他帐套引入的,在第一期计体提折旧错误,提示使用null无效(facardin101.rar)问题定位出现这种问题，一般的问题是参与折旧的记录丢失，到底是丢失了那些数据（方向）：上期余额，卡片等记录丢失，如果是启用期间，则上期记录为初始记录，期间为0的记录select * from t_fabalance where fperiod=0 and fyear=2005找出问题的根本原因Se