收款单和现结重号
发布于:2018-02-05 13:42:58
问题现象:在增加收款单和现结时不能保存,单据号重复
解决方案:请在查询分析器中针对错误帐套的06年度执行下面语句,注意执行前需要将 xxx 替换成实际的帐套号: update ufsystem..ua_identity set ifatherid=(select max(right(bpayment,4)) from salebillvouch ) where cacc_id='xxx' and cvouchtype='xj' update ufsystem..ua_identity set ifatherid=(select max(iid) from ap_closebills ), ichildid=(select max(id) from ap_closebills ) where cacc_id='xxx' and cvouchtype='sk'