云星空即时库存金额

SELECT FNAME 仓库, SUM(FBASEQTY*入库单价) 金额 FROM (SELECT FBASEQTY,B.FNAME,A.FMATERIALID FROM T_STK_INVENTORY a
inner join T_BD_STOCK_L b on A.FSTOCKID=B.FSTOCKID
WHERE FSTOCKORGID=1 AND FBASEQTY>0 and b.FLOCALEID=2052
)A
INNER JOIN (
SELECT FMATERIALID,FNUMBER 物料代码,FNAME 物料名称,FSPECIFICATION 规格型号, CAST(FPRICE as decimal(18,6)) 入库单价 FROM 
(select *,row_number()over(partition by FNUMBER,FNAME,FSPECIFICATION order by  FAPPROVEDATE desc,FPRICE)序号 FROM
(select A.FMATERIALID,B.FAPPROVEDATE,A.FID,D.FNUMBER,C.FPRICE,E.FNAME,E.FSPECIFICATION from T_STK_INSTOCKENTRY A   --入库明细
INNER JOIN T_STK_INSTOCK B ON B.FID=A.FID --入库单
LEFT JOIN T_STK_INSTOCKENTRY_F C ON C.FENTRYID=A.FENTRYID --入库明细单价
INNER JOIN T_BD_MATERIAL D ON D.FMATERIALID=A.FMATERIALID --物料表
INNER JOIN T_BD_MATERIAL_L E ON E.FMATERIALID=A.FMATERIALID --物料多语言
where  A.FKEEPERID=1  --组织   
 
AND B.FCANCELSTATUS='A' --禁用状态
AND B.FDOCUMENTSTATUS='C')F)G --单据状态
WHERE G.序号=1 ) B ON A.FMATERIALID=B.FMATERIALID GROUP BY FNAME