查询收发存汇总表提示“下标越界”
发布于:2018-02-05 12:21:02
问题现象:按照收发类别查询收发存汇总表提示“下标越界”
解决方案:在sql的查询分析器中执行下面语句,将单据和存货明细账中的出库类别错误的设置为null值,然后查询收发存汇总表就正常了: update ia_subsidiary set crdcode=null where brdflag=0 and crdcode like '1%' update rdrecord set crdcode=null where brdflag=0 and crdcode like '1%'