KIS 专业版10.0 凭证过账提示“名称代码已被使用”

亲近大地

如题，KIS 专业版10.0 凭证过账时，提示“名称代码已被使用”，不能过账，请求支援。谢谢了！

qiangsheng

金蝶软件中科目代码和另外一个科目重了。

亲近大地

回复 qiangsheng 的帖子

首先，谢谢你！
我再描述一下具体症状，这个月有198张凭证，我一次过二十张凭证，没有问题，这样过10次账，就把这198张凭证过完了账。但是不能一次全部过账，如果一次过198张凭证，就出现上面的错误提示。也不能成批的反过账。郁闷！

lengyue7

备份好帐  反结帐,反初始化 到查询分析器中执行以下语句
exec sp_cleanitemdetailv
update a set a.fdetailcount=b.Fcount from t_itemdetail a join (select Fdetailid,count(Fitemid) Fcount from t_itemdetailv where fitemid<>0 group by Fdetailid) b on a.fdetailid=b.fdetailid
exec sp_cleanitemdetailv
update t_account set Fdetailid =(select min(fdetailid) from t_itemdetail where fdetailid in (select Fdetailid from t_itemdetailv where fitemid=-1) and Fdetailcount=1 and F2=-1 ) where Fdetailid in (select (fdetailid) from t_itemdetail where fdetailid in (select Fdetailid from t_itemdetailv where fitemid=-1) and Fdetailcount=1 and F2=-1 )

delete from t_itemdetail where Fdetailid in(select (fdetailid) from t_itemdetail where fdetailid in (select Fdetailid from t_itemdetailv where fitemid=-1) and Fdetailcount=1 and F2=-1 ) and Fdetailid <>(select min(fdetailid) from t_itemdetail where fdetailid in (select Fdetailid from t_itemdetailv where fitemid=-1)and Fdetailcount=1 and F2=-1 ) exec sp_cleanitemdetailv
select * from t_balance where fdetailid not in (select fdetailid from t_itemdetail)
delete from t_balance where fdetailid not in (select fdetailid from t_itemdetail)

select * from t_quantitybalance where fdetailid not in (select fdetailid from t_itemdetail)

delete from t_quantitybalance where fdetailid not in (select fdetailid from t_itemdetail)

select * from t_profitandloss where fdetailid not in (select fdetailid from t_itemdetail)

delete from t_profitandloss where fdetailid not in (select fdetailid from t_itemdetail)


select * from t_itemdetail where fdetailid in (select fdetailid from t_itemdetailv where fitemid=-1)

UNDEE

没有遇到过这样的问题，同时过几百张好像都没有问题

亲近大地

回复 lengyue7 的帖子

谢谢你的帮助！帐套使用好几年了，反结账，反初始化，好像不大可能了。有没有其他办法？

亲近大地

回复 亲近大地 的帖子

有哪位同仁给留意下，这个问题，相信会解决。

sdlzf

老问题了，到网上搜索一下，有很多解决方法！