有些商品有现存量，但在录入批次时却无数量，无法参照批次问题描述：数据问题：该客户说有些商品有现存量，但在录入批次时却无数量，无法参照批次。如02库商品编码为01010208-1 的商品。 解决办法：经检查rdrecords表中该入库记录的累计出库数（isoutquantity）计算有误，请运行下列语句可查询该用户所有出库数合计与系统自动计算的 isoutquantity数之间的差异，按照正确的修改该isoutquantity字段值即可，其中ljckquantity为rdrecords表中某存货某批次的出库数合计，isoutquantity为系统计算出的累积出库数。一定注意：由于该用户在销售系统选项中选择的是‘在销售系统指定批次’，并且由库存系统生成销售出库单，当在销售系统开发货单，其待发数量即写入rdrecords的isoutquantity字段（系统自动完成），目前待发数无法与 rdrecords相关联，所以使用该语句前必须全部生成销售出库单才行，您先将数据备份后，在库存系统一次完成生单工作。运行该语句后即知那些存货记录有错，再进一步更改即可。 if exists(select * from sysobjects where name='a') drop table a go if exists(select * from sysobjects where name='b') drop table b go if exists(select * from sysobjects where name='c') drop table c SELECT cvouchcode, cinvcode, cbatch, SUM(iquantity) AS ckquantity INTO a FROM RdRecords INNER JOIN RdRecord ON RdRecords.ID = RdRecord.ID WHERE (RdRecords.cVouchCode IS NOT NULL) AND (RdRecord.cVouchType <> '01') and (RdRecord.cVouchType <> '08') group by RdRecords.cvouchcode,RdRecords.cinvcode, RdRecords.cbatch SELECT RdRecords.cinvcode,RdRecords.cbatch,RdRecords.cvouchcode, abs(SUM(iquantity) )AS cgthquantity into b FROM RdRecords INNER JOIN RdRecord ON RdRecords.ID = RdRecord.ID WHERE (RdRecords.cVouchCode IS NOT NULL) AND (RdRecord.cVouchType in( '01','08')) group by RdRecords.cvouchcode,RdRecords.cinvcode, RdRecords.cbatch select a.cvouchcode, a.cinvcode, a.cbatch, a.ckquantity+isnull(b.cgthquantity,0) as ljckquantity into c from a left join b on a.cvouchcode=b.cvouchcode and a.cinvcode=b.cinvcode and a.cbatch=b.cbatch selectc.cvouchcode,rdrecords.autoid,c.cinvcode,rdrecords.cinvcode, c.cbatch,rdrecords.cbatch,c.ljckquantity,rdrecords.isoutquantity from c join rdrecords on c.cvouchcode=rdrecords.autoid and c.cinvcode=rdrecords.cinvcode and c.cbatch=rdrecords.cbatch where c.ljckquantity<>rdrecords.isoutquantity