—新品基础资料缺失
    SELECT bs.crna,bs.crdt,bs.inco,w.inna ,w.vole,w.vowi,w.vohe,w.volu,w.newe,w.grwe—,w.stat ,w.cpfl,w.cpty ,w.cpri,i.days,bs.boty,bs.baty,CASE WHEN bs.boty=’06’ THEN ‘虚拟批次码’WHEN bs.boty=’04’ THEN ‘物料码’ ELSE bs.boty END AS ‘码制’
    ,CASE WHEN bs.baty=’01’ THEN ‘生产批号管理’ ELSE bs.baty END AS ‘批次管理方式’
    FROM bast bs LEFT JOIN inve w ON w.inco=bs.inco LEFT JOIN vali i on i.inco=w.inco
    WHERE bs.crdt >’2021/07/01 00:00:00’
    ORDER BY bs.crdt

    —效期预警
    SELECT DISTINCT a.whco,wa.whna,a.whid,a.inco,a.qty,n.inna ,datediff( day, GETDATE(),t.dqdt)yjts
    ,i.days,t.csdt,t.dqdt,n.cpfl,n.cpty ,n.cpri—,a.cotl ,w.whty,t.rkno
    FROM bain a —库存表
    LEFT JOIN bast b ON a.inco=b.inco AND b.cotl=a.cotl —货主物料配置
    LEFT JOIN waho w ON w.whid=a.whid —仓库
    LEFT JOIN waho wa ON wa.whid=a.whco —仓库
    LEFT JOIN vali i on i.inco=a.inco —有效期预警（天）
    LEFT JOIN btin t ON t.inco=a.inco AND t.cotl=a.cotl and a.btno=t.btno —批次信息
    left join inve n on a.inco = n.inco —商品档案
    WHERE b.baty=’01’ and i.stat = ‘0’ —baty(01生产批号管理，03到期日期管理;boty(04物料码，06虚拟批次码
    AND datediff( day, GETDATE(), t.dqdt)<=0— convert(decimal(15,6),i.days)
    ORDER BY a.whco,wa.whna

    —全仓无库存的包装
    SELECT WHCO ,I.INCO,I.inna,I.stat,SUM(ISNULL(QTY,0)) FROM inve i
    LEFT JOIN stquo s ON s.inco=i.inco
    WHERE i.inpr IN (‘B’)

    GROUP BY WHCO,I.INCO,I.inna,I.stat HAVING SUM(ISNULL(QTY,0))=0