PMP en query

[felipe_loyolarodriguez]

Estimados

tengo la siguiente query

SELECT T1.[WhsCode], T1.[WhsName], T0.[ItemCode], T2.[ItemName], 
(SELECT (SUM(Y.InQty)-SUM(Y.OutQty)) FROM OINM Y WHERE Y.ItemCode = T2.ItemCode AND Y.Warehouse = T1.WhsCode AND Y.DocDate BETWEEN '[%0]' AND '[%1]') 'Stock',
(SELECT Y.CalcPrice FROM OINM Y WHERE Y.TransNum IN (SELECT MAX(Y1.TransNum) FROM OINM Y1 WHERE Y1.DocDate IN (SELECT MAX(Y2.DocDate) FROM OINM Y2 WHERE Y2.DocDate <= '[%0]' AND Y2.ItemCode = Y1.ItemCode) AND Y1.ItemCode = Y.ItemCode) AND Y.ItemCode = T2.ItemCode) 'PMP'
FROM OITW T0
INNER JOIN OWHS T1 ON T0.WhsCode = T1.WhsCode 
INNER JOIN OITM T2 ON T0.ItemCode = T2.ItemCode
WHERE (SELECT (SUM(Y.InQty)-SUM(Y.OutQty)) FROM OINM Y WHERE Y.ItemCode = T2.ItemCode AND Y.Warehouse = T1.WhsCode AND Y.DocDate BETWEEN '20010101' AND '[%0]') != '0'
ORDER BY T0.[WhsCode], T0.[ItemCode]

SI tiro el informe al 31 de dic, los articulos que tienen el ultimo movimiento a esa fecha, me aparece el PMP correcto

pero los que no, me arroja un PMP erroneo.

La idea es seleccionar el ultimo PMP que se calculo a la fecha del infome, como puedo solucionar ese problema? a alguien se le ocurre?

Saludos

FLR

[felipe_loyolarodriguez]

Closed.