1、执行sqldropviewv_check_ww;createviewv_check_wwasselecta.cfirstbillbid,sum(b.noutnum)outnumfromic_general_baleftjoinic_general_bbona.cfirstbillbid=b.cfirstbillbidleftjoinic_general_hhonh.cgeneralhid=b.cgeneralhidwherea.cfirsttypein('61','20')andh.cbilltypecode='4F'andb.dr=0groupbya.cfirstbillbidhavingsum(b.noutnum)>02、委托加工入库单增加验证公式;outnum->getColValue(v_check_ww,outnum,cfirstbillbid,cfirstbillbid);$Error->iif(outnum==null&&ninnum>0,"当前行"+crowno+"没有发料,无法出库","")效果如下:只有做完发料后,才能入库