問題現(xiàn)象：821做暫估處理時提示:xxx單據(jù)暫估處理失敗;在記賬時提示:xxx單據(jù)記賬失敗.
解決方案：執(zhí)行如下語句即可: delete ia_summary from ia_summary join select cwhcode,cinvcode from ia_summary where imonth=‘3‘ group by cwhcode,cinvcode having count*>1 b on ia_summary.cwhcode=b.cwhcode and ia_summary.cinvcode=b.cinvcode where imonth=‘3‘ and autoid not in select maxautoid from ia_summary where imonth=‘3‘ group by cwhcode,cinvcode having count*>1