解决方案: |
可在整理现存量后,使用下面语句更改销售订单上的累计预留量,然后再释放,建议您以后出库时请根据销售订单出库,这样现存量表中该订单的现存量会自动减少。并且请查看您的操作过程,是否产成品入库保存时有问题或者是通过其它工具导入到数据库中的,导致没有回写销售订单上的累计预留量,因为在您的帐套上测试一个销售订单对应的生产订单作产成品入库,保存后销售订单上的累计预留量随之更改,并没有出现您数据中目前的问题。
update a set iprekeeptotquantity=b.iq,iprekeeptotnum=b.inum
from so_sodetails a inner join
(select sum(iquantity) as iq,sum(inum) as inum,isodid from currentstock
where cinvcode in (select cinvcode from inventory where
csrpolicy='lp') group by isodid) b on a.isosid=b.isodid
update a set iprekeepquantity=b.iq,iprekeepnum=b.inum
from so_sodetails a inner join
(select sum(iquantity) as iq,sum(inum) as inum,isodid,cinvcode from currentstock
where cinvcode in (select cinvcode from inventory where
csrpolicy='lp') group by isodid,cinvcode) b
on a.isosid=b.isodid and a.cinvcode=b.cinvcode
|