格搜：采购订单-获取供应商最后一次采购报价含税单价

SELECT T0.[PriceAfVAT] FROM PQT1 T0  INNER JOIN OPQT T1 ON T0.[DocEntry] = T1.[DocEntry] INNER JOIN 
(
		SELECT T1.[CardCode],T0.[ItemCode], MAX(T0.[ShipDate]) AS 'DATE'
		FROM PQT1 T0 INNER JOIN OPQT T1 ON T0.[DocEntry] = T1.[DocEntry]
		GROUP BY T1.[CardCode],T0.[ItemCode]
	) TS ON TS.itemcode = t0.itemcode AND TS.[CardCode]=T1.[CardCode]
 WHERE T0.[ShipDate] = TS.date AND T0.[ItemCode]=$[$38.1.1] AND T1.[CardCode]=$[$4.0.1]

五六零

海报 链接