固定资产计提折旧时提示:使用NULL无效,错误代码:94(5EH)

固定资产计提折旧时提示:使用NULL无效,错误代码:94(5EH)

固定资产计提折旧时提示:使用NULL 无效,错误代码:94(5EH)

问题原因: 固定资产计提折旧提示NULL 无效,通常有以下几种情况:

情况一:由标准版升级上来或用历史数据清除工具清除历史数据时丢失了0 期记录(初始化记录)的帐套;

情况二:引进卡片或结转新帐套的帐套,帐套被引入或保留了固定资产启用期间之前的记录,而启用当期又没有0 期记录(初始化记录);

情况三:日常期间丢失了大量余额记录的帐套。

情况一:如果固定资产丢失0 期记录,可参考下面方式处理

1、通过语句删除固定资产所有余额记录,将帐套反初始化(假设启用期间为

2006 年1 期)

delete from t_fabalcard

delete from t_fabalcarditem

delete from t_fabaldept

delete from t_fabaldevice

delete from t_fabalexpense

delete from t_fabalorgfor

delete from t_fabalpurchase

delete from t_fabalance

update t_systemprofile set fvalue=0 where fcategory='fa' and fkey='Closed'

update t_systemprofile set fvalue=2006 where fcategory='fa' and fkey=' CurrentYear'

update t_systemprofile set fvalue=01 where fcategory='fa' and fkey=' CurrentPeriod'

2、重新编辑保存初始化卡片,再结束初始化

3、对日常业务中的新增卡片和变动记录重新编辑、保存、提折旧,再一期一期

结帐。根据不同的帐套环境,有的帐套重新保存卡片时候需要对原来卡片添加

一点备注才能在余额表重写记录。

情况二:如果固定资产有启用期间之前的完整记录,可以通过修改参数表把启用期间提前处理(提前到t_fablance 表中的最前期间),也可以通过删除以前的记录,补充0 期记录处理。前者更简单。

update t_systemprofile set fvalue=???? where fcategory='fa' and fkey='StartYear'

update t_systemprofile set fvalue=?? where fcategory='fa' and fkey='Startperiod'

情况三:如果帐套从结束初始化当期开始有大量卡片的余额记录丢失,需要通过反结帐反初始化,删除余额记录(只保留0 期记录),直接关闭初始化,再对日常业务的卡片重新编辑、保存、提折旧、结帐。

—-删除余额记录与情况一略有不同,其他步骤一样

select * into t_fabal_temp from t_fabalance where fperiod<>0

delete from t_fabalcard where fbalid in (select fbalid from t_fabal_temp)

delete from t_fabalcarditem where fbalid in (select fbalid from t_fabal_temp)

delete from t_fabaldept where fbalid in (select fbalid from t_fabal_temp)

delete from t_fabaldevice where fbalid in (select fbalid from t_fabal_temp)

delete from t_fabalexpense where fbalid in (select fbalid from t_fabal_temp)

delete from t_fabalorgfor where fbalid in (select fbalid from t_fabal_temp)

delete from t_fabalpurchase where fbalid in (select fbalid from t_fabal_temp)

delete from t_fabalance where fbalid in (select fbalid from t_fabal_temp)

drop table t_fabal_temp

update t_systemprofile set fvalue=0 where fcategory='fa' and fkey='Closed'

update t_systemprofile set fvalue=???? where fcategory='fa' and fkey=' CurrentYear'

update t_systemprofile set fvalue=?? where fcategory='fa' and fkey=' CurrentPeriod'

分享到 :
相关推荐

Leave a Reply

Your email address will not be published. Required fields are marked *