金蝶KIS专业版删除固定资产变动记录,软件里删除时提示:“数据已存在”。

[全站通告] 想快速节省您的时间并可接受付费的朋友,可扫右边二维码加博主微信-非诚勿扰!

症状:

固定资产卡片最近一次变动记录删除不了,删除时提示:“数据已存在”。

解决方法:

执行以下语句
–删除固定资产变动记录,FAlterID为变动记录号
delete from t_FAExpense where FAlterID = 220
delete from t_FAVoucher where FAlterID = 220
delete from t_faorgfor where FAlterID = 220
delete from t_facarditem where FAlterID = 220
delete from t_FADept where FAlterID = 220
delete from t_FACard where FAlterID = 220
delete from t_FAAlter where FAlterID = 220

发表回复

加入本站SVIP会员,海量资源免费查看下载

目前为止共有167位优秀的SVIP会员加入! 立即加入!