2024年4月12日发(作者：)

收发存报表（按仓库查询）

包含字段：物料编号T0.[ItemCode]，物料描述T0.[ItemName]，物料组

T0.[ItmsGrpCod]，时间范围，仓库T1.[WhsCode]，期初结存=入库inqty-出库outqiy，

本期入库inqty，本期出库outqty，期末结存 = 期初+入库-出库（注：OINM库存日记

账，OWHS仓库主数据，OITW仓库物品列表，OITB物料组）

起初日期

DECLARE @DateFrom DATE

DECLARE @DateTo DATE

/*SELECT FROM [dbo].[OINM] T0*/

SET @DateFrom =/* e */'[%1]';

SET @DateTo =/* e */'[%2]';

SELECT de[物料编号] ,me[物料描述] ,

ty[期初结存] ,SUM()[本期入库] ,SUM()[本期出

库] ,[期末结存],e[仓库]

FROM OITM T0

LEFT JOIN OITW T1 ON de = de

LEFT JOIN OWHS T3 ON e = e

LEFT JOIN (SELECT

ItemCode ,Warehouse ,SUM(InQty)[InQty],SUM(OutQty)[OutQty]

FROM OINM WHERE DocDate >= @DateFrom AND DocDate <= @DateTo

GROUP BY ItemCode ,Warehouse ) T4 ON de = de AND

e = use

LEFT JOIN (SELECT ItemCode ,Warehouse ,SUM(InQty - OutQty)[BeginQty]

FROM OINM WHERE DocDate < @DateFrom

GROUP BY ItemCode ,Warehouse ) T5 ON de = de AND

e = use

LEFT JOIN (SELECT ItemCode ,Warehouse ,SUM(InQty - OutQty)[EndQty]

FROM OINM WHERE DocDate <= @DateTo

GROUP BY ItemCode ,Warehouse ) T6 ON de = de AND

e = use

GROUP BY de ,me ,e,ty ,