从标准版升级到的15.0账套
固定资产变动/清理：该数据有错或被其他用户删除,请刷新后重试!

数据库查询很多相同记录，删除FAlterID 最大值，保留最小值之后 固定资产还是无法变动

求高手解惑~~等了很久，然并卵！
自己搞研究搞，分享方法：
----------删除相同记录ID最大号的卡片和变动记录--------------------------

select FAlterID into ##bear9527
from t_FACard
where FAlterID in
(
select FAlterID from T_FACARD where
FAssetNumber in (select FAssetNumber from T_FACARD group by FAssetNumber having count(FAssetNumber)>1)
and FAlterID in (select max(FAlterID) from T_FACARD group by FAssetNumber having count(FAssetNumber)>1)
)

delete from t_FACard where FAlterID in (select FAlterID from ##bear9527)
delete from t_FAClear where FAlterID in (select FAlterID from ##bear9527)
delete from t_FADevice where FAlterID in (select FAlterID from ##bear9527)
delete from t_FACardItem where FAlterID in (select FAlterID from ##bear9527)
delete from t_FADept where FAlterID in (select FAlterID from ##bear9527)
delete from t_FAExpense where FAlterID in (select FAlterID from ##bear9527)
delete from t_FAVoucher where FAlterID in (select FAlterID from ##bear9527)
delete from t_FAOrgFor where FAlterID in (select FAlterID from ##bear9527)
delete from t_FAPurchase where FAlterID in (select FAlterID from ##bear9527)
delete from t_faalter where FAlterID in (select FAlterID from ##bear9527)
drop table ##bear9527
go

仅供参考，执行代码前，请备份账套，出现问题与本人无关哈！

太牛了，标准版升级到专业版16,0的账套也成功解决。

这个是不是通用的？
学习学习
楼主牛B
自己搞定~~:/lol
只删除卡片重复记录 还不行，自己慢慢搞定了~~哎，提单次数用完了，还要收费，，，
遇见同类问题的朋友可以交流哈
那您按提示刷新或者退出软件重新登录，这条记录还存在吗？如果仍然存在，操作仍然是以上提示，请进行账套提单处理，有可能是数据异常了
附如何上传账套及提单：
http://cloud.kingdee.com/kdrive/share/link?key=MjAxODMxLDEwMzY3OQ