SELECT * FROM

(

SELECT C.FFINORGID FORGID,M.FMATERIALID,M.FNUMBER,O.FYEAR,O.FPERIOD,ST.FSTOCKID,

SUM(CASE WHEN B.FENDINITKEY=0 THEN B.FQTY ELSE 0 END) AS 期初数,

SUM(CASE WHEN B.FENDINITKEY=0 THEN B.FAMOUNT ELSE 0 END) AS 期初金额,

SUM(CASE WHEN B.FENDINITKEY=1 THEN B.FCURRENTINQTY ELSE 0 END) AS 入库数,

SUM(CASE WHEN B.FENDINITKEY=1 THEN B.FCURRENTINAMOUNT ELSE 0 END) AS 入库金额,

SUM(CASE WHEN B.FENDINITKEY=1 THEN B.FOUTSTOCKQTY ELSE 0 END) AS 出库数,

SUM(CASE WHEN B.FENDINITKEY=1 THEN B.FCURRENTOUTAMOUNT ELSE 0 END) AS 出库金额,

SUM(CASE WHEN B.FENDINITKEY=1 THEN B.FQTY ELSE 0 END) AS 期末数,

SUM(CASE WHEN B.FENDINITKEY=1 THEN B.FAMOUNT ELSE 0 END) AS 期末金额

FROM T_HS_BALANCE B --核算信息

LEFT JOIN T_HS_STOCKDIMENSION S ON B.FDIMEENTRYID=S.FENTRYID --物料

LEFT JOIN T_HS_CALDIMENSIONS C ON B.FDIMENSIONID=C.FDIMENSIONID --核算组织

LEFT JOIN T_HS_OUTACCTG O ON B.FID=O.FID --年月

LEFT JOIN T_BD_MATERIAL M ON S.FMASTERID=M.FMASTERID AND C.FFINORGID=M.FUSEORGID

LEFT JOIN T_ORG_ORGANIZATIONS_L L ON L.FORGID=C.FFINORGID AND L.FLOCALEID=2052

LEFT JOIN T_BD_STOCK AS ST ON ST.FSTOCKID =S.FSTOCKID

GROUP BY C.FFINORGID,M.FMATERIALID,O.FYEAR,O.FPERIOD,M.FNUMBER,ST.FSTOCKID

UNION

产品问题sql 报表 按仓库生成存货收发汇总表 云星空7.6版本

20 产品问题 sql 报表 按仓库生成存货收发汇总表 云星空7.6版本