亚洲高清Av无码在线,少妇高潮抽搐无码久久AV,东京一区二区三区高清视频,99re热精品视频下载,久久天天躁综合夜夜2020,国产在线看片免费视频,人妻夜爽一天天一爽

在使用KIS專業(yè)版進(jìn)行憑證過帳時(shí),提示"名稱或代碼在系統(tǒng)中已被使用"(錯(cuò)誤代碼:3604 E14H)

如果提示F1

備份賬套后，執(zhí)行以下SQL后，再過賬：

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

如果提示F2

select * from t_itemdetail
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