固定资产计提折旧时提示:使用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’