固定资产以前期间都正常,到了某一期才表现异常。适用下面脚本。请注意去修改里面的期间(下面脚本中的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
)