821做暂估处理时提示:xxx单据暂估处理失败
发布于:2018-03-16 09:20:38
问题现象:821做暂估处理时提示:xxx单据暂估处理失败;在记账时提示:xxx单据记账失败.
解决方案:执行如下语句即可: 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