select freplacegroup,min((FBASEPICKEDQTY+FBASEREPICKEDQTY-FBASESCRAPQTY-FBASEGOODRETURNQTY-FBASEINCDEFECTRETURNQTY-FBASEPRCDEFECTRETURNQTY)*FBASEDENOMINATOR /a.FBASENUMERATOR ) from T_PRD_PPBOMentry a inner join T_PRD_PPBOMENTRY_q b on a.fentryid=b.fentryid where a.fid=102527 and a.fmustqty<>0 group by freplacegroup
领料套数计算公式:用料清单每一行分录上已领+补料-报废-良品退料-作业不良-来料不良*分母/分子/(1-物料上的消耗波动/100),然后计算找到最小值就是领料套数了
报表和订单的领料套数是不考虑波动消耗的,材料领用套数校验会考虑波动消耗
未领数量计算公式:应发-已领+良品退料+来料不良
select
q.FNOPICKEDQTY as 未领数量,q.fbasenopickedqty 基本单位未领数量,b.FMUSTQTY 应发数量,b.FBASEMUSTQTY 基本单位应发数量,
q.FGOODRETURNQTY 良品退料,q.FBASEGOODRETURNQTY 基本单位良品退料,q.FINCDEFECTRETURNQTY 来料不良,q.FBASEINCDEFECTRETURNQTY 基本单位来料不良,
q.* from T_PRD_PPBOM a
inner join T_PRD_PPBOMENTRY b on a.FID=b.FID
inner join T_PRD_PPBOMENTRY_Q q on b.FENTRYID=q.FENTRYID
where a.FBILLNO='PPBOM00000005'