解决方案: |
在单据编号设置中,将单据流水位数根据实际情况增加。 【注意事项】 由于您给发过来的数据只有年度帐,在保存发票及现结时提示主键约束错误,该错误可以通过以下脚本修改。若用户出也出现同样的错误,也可以用下面的语句修改。 update ufsystem..ua_identity set ifatherid=(select max(cast(substring(ccancelno,3,len(ccancelno)) as int)) from ap_closebill where ccancelno is not null and left(ccancelno,2)='xj'),ichildid=(select max(id) from ap_closebills) where cacc_id='666' and cvouchtype='xj' update ufsystem..ua_identity set ifatherid=(select max(sbvid) from salebillvouch),ichildid=(select max(autoid) from salebillvouchs) where cacc_id='666' and cvouchtype='billvouch' update ufsystem..ua_identity set ifatherid=(select max(iid) from ap_closebill),ichildid=(select max(id) from ap_closebills) where cacc_id='666' and cvouchtype='sk' |