解决方案: |
首先,对于生产备料单内的数据,软件统计的是没有全部领料的存货信息.全部领料的存货,将不在此列示.敬请注意. 其次,您所描述的现象,是由于用户数据错误引起,主要原因是Rdrecords表中的收发记录,与PP_PoMain和PP_PoDetails表中的相应记录不能对应,请运行如下语句可以分别解决1,2问题:
1.解决问题1的脚本:
update pp_podetails
set pp_podetails.fOutQuantity = b.allQuantity
from pp_podetails , (select sum (iQuantity) as allQuantity,cMpocode,cinvcode
from rdrecord r , rdrecords rs
where cVouchType = '11' and r.id = rs.id
and cMpocode is not null group by cMpocode,cinvcode) b
where pp_podetails.fOutQuantity <> b.allQuantity
and pp_podetails.ccode = b.cMpocode
and pp_podetails.cinvcode = b.cinvcode
2.解决问题2的脚本:
update pp_pomain
set pp_pomain.finQuantity = b.allQuantity
from pp_pomain pm , (select distinct ccode, mainid from pp_podetails) as pd,
(select sum (iQuantity) as allQuantity,cMpocode,cinvcode
from rdrecord r , rdrecords rs where cVouchType = '10'
and r.id = rs.id and cMpocode is not null group by cMpocode,cinvcode) as b
where pm.fInQuantity <> b.allQuantity
and pd.ccode= b.cMpocode
and pm.mainid = pd.mainid
and pm.cinvcode = b.cinvcode |