問題現(xiàn)象：現(xiàn)結(jié)銷售發(fā)票審核時(shí)提示“發(fā)票已經(jīng)被審核”，經(jīng)查找原因?yàn)椋簩?shí)際發(fā)票并沒有審核過，Ap_CloseBill表中ccancelman字段；salebillvouch中的bpayment字段 出現(xiàn)重復(fù)
解決方案：-- 檢查、修改ufsystem SELECT * FROM ufsystem..UA_Identity WHERE (cAcc_Id = '004') AND (cVouchType = 'xj') update ufsystem..UA_Identity set ifatherid=(SELECT max(ccancelno) FROM ufdata_004_2004..ap_closebill) WHERE (cAcc_Id = '004') AND (cVouchType = 'xj') update ufsystem..UA_account_sub set bclosing=1 where cacc_id='004' and (csub_id='AR' or csub_id='SA') AND iyear=2003 --修改AP_Closebill update a set ccheckman=null from ap_closebill a,salebillvouch b where b.bpayment=a.ccancelno and b.bpayment is not null and b.cVerifier is null and a.cCheckMan is not null 注意做好帳套數(shù)據(jù)備份?。?