KIS固定资产异常处理方法

固定资产以前期间都正常,到了某一期才表现异常。适用下面脚本。请注意去修改里面的期间(下面脚本中的202002需要根据实际情况修改)。提示,操作数据有风险,请操作前做好数据库备份。

注意如果当期有新增固定资产,需要把这些新增的固定资产删除后重新增加。再去反结账到前面一期去重新计提折旧。然后结账后计提一般就可以正常计提了。

delete    t_FABalExpense where  Fbalid  in(   select Fbalid from t_fabalance where Fyear*100+Fperiod>=202002)

delete t_FABalOrgFor   where  Fbalid  in(   select Fbalid from t_fabalance where Fyear*100+Fperiod>=202002)

delete t_FABalDept where Fbalid  in(   select Fbalid from t_fabalance where Fyear*100+Fperiod>=202002)

delete t_FABalCardItem where Fbalid in(   select Fbalid from t_fabalance where Fyear*100+Fperiod>=202002)

delete t_FABalCard where Fbalid in(   select Fbalid from t_fabalance where Fyear*100+Fperiod>=202002)

delete from t_FABalDevice where FBalID  in(  select Fbalid from t_fabalance where Fyear*100+Fperiod>=202002)

delete    t_fabalance where Fyear*100+Fperiod>=202002

delete

from t_FABalCardItem where FBalID not in(

select FBalID from  t_FaBalExpense

)

delete

from t_FABalDept where FBalID not in(

select FBalID from  t_FaBalExpense

)

delete

from t_FABalOrgFor where FBalID not in(

select FBalID from  t_FaBalExpense

)

delete

from t_FABalCard where FBalID not in(

select FBalID from  t_FaBalExpense

)

发表回复

您的电子邮箱地址不会被公开。 必填项已用 * 标注