格搜：采购订单单价-目标价格等于该供应商最后一次报价价格

SELECT top 1 T1.[Price] FROM OPQT T0  INNER JOIN PQT1 T1 ON T0.[DocEntry] = T1.[DocEntry] 
where t0.cardcode=$[OPOR.CardCode]  and t1.itemcode=$[POR1.ItemCode] AND T0.[CANCELED]='N' AND T0.[DocStatus]='O'
ORDER BY T0.[DocNum] DESC

五六零

海报 链接