金蝶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