用友U8CLOUD高手进阶系列-供应链-u8c2.0销售管理-查询有出库但是未开发票的销售订单.txt

--查询有出库但是未开发票的销售订单selectdistinctpo.vreceiptcodefrombd_corpbp,so_salepo,so_saleexecutepb,bd_busitypebusi,so_saleorder_bsowherepo.dr=0andpb.dr=0andso.dr=0andpo.pk_corp=bp.pk_corpandpo.pk_corp=so.pk_corpandpo.csaleid=pb.csaleidandpo.cbiztype=busi.pk_busitype-----andpb.ntotalinvoicenumber0andnvl(pb.ntotalinvoicenumber,0)=0----and（pb.ntotalinvoicenumber=0orpb.ntotalinvoicenumberisnull）--已经存在出库，但是累计发票数量字段是空值andpo.dbilldate<='2018-04-20'-------andbusi.busicode='c001'andbusi.pk_corp='1001'andpb.bsquareendflag='N'--未关闭订单