金蝶KIS專業版憑證過賬提示“名稱或代碼在系統中已被使用"

方法一：
exec sp_cleanitemdetailv
go
update a set a.fdetailcount=b.Fcount
from t_itemdetail a join (select Fdetailid,count(*) as Fcount from t_itemdetailv
where fitemid=-1 group by Fdetailid) b
on a.fdetailid=b.fdetailid where a.fdetailcount<>b.Fcount
go

方法二：

update d set d.fdetailcount=v.fcount
from t_ItemDetail d,
(select fdetailid,count(*) fcount from t_ItemDetailv where fitemid=-1 group by fdetailid ) v
where d.fdetailid=v.fdetailid
go

方法三：(已測試過)
update d set d.fdetailcount=v.fcount
from t_ItemDetail d,
(select fdetailid,count(*) fcount from t_ItemDetailv where fitemid=-1 group by fdetailid ) v
where d.fdetailid=v.fdetailid