SELECT 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
金蝶Cloud取物料最后一次采购入库价格
最新推荐文章于 2024-02-19 16:34:01 发布