固定资产折旧专题(初级Ⅴ).ppt

固定资产折旧专题(初级Ⅴ)
：固定资产在计提折旧时出现“科目没有权限,5(5H)的错误代码”提示
只要是科目没有权限，或核算项目无权限，则一定是t_fabalexpense,或t_faexpense中的facctid况
修改卡片日期及启用期间
update t_systemprofile set fvalue=2005 where fcategory='fa' and fkey='StartYear'—
update t_systemprofile set fvalue='2005-01-01' where fcategory='fa' and fkey='StartDate'--2005-06-23
update t_faalter set fdate='2005-07-05' where fperiod=7
update t_faalter set fdate='2004-12-31' where fperiod=0
update t_fabalance set fdate='2004-12-31',faltdate='2004-12-31' where faltdate<>'2005-07-05'
update t_fabalance set fdate='2005-07-05',faltdate='2005-07-05' where fassetid=1239
update t_faalter set fnew=1----fnew,fcleaned,fotheralter必须有唯一值
卡片是从别的帐套引入进来，卡片数据不完整，经过前面处理，还是解决不了问题
对引入的卡片，出现问题，最好的解决方法是，回到初始化期间，在初始化进行数据调整
select * from t_faalter ---1239
select * from t_facard--1239
select * from t_fadept---259
select * from t_faexpense--270
select * from t_facarditem—1239
查找丢失记录的表，然后补回数据
找出问题的根本原因
delete from t_fadept
insert into t_fadept
select distinct ,,, from t_fabalance b inner join t_fabaldept d on =
inner join t_faalter a on = order by falterid
delete from t_faexpense
insert into t_faexpense
select distinct ,,,, from t_fabalance b
inner join t_fabalexpense d on = inner join t_faalter a on =
找出问题的根本原因
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_