Query de material faltante

[EdissonFlorez]

hola,

me podrian ayudar a definir este query para que solo me traiga los valores negativos

gracias

[SidV]

Pasa el Query como texto

[EdissonFlorez]

este es el query

SELECT T0.ItemCode, T0.ItemName, T0.InvntryUom, T0.OnHand, T0.IsCommited as 'Comprometido', T0.OnOrder as 'Solicitado', T0.OnHand - T0.IsCommited  as 'Faltante' 
FROM OITM T0 
WHERE (T0.[IsCommited] > (0 ) )

[GabrielGS]

Muy sencillo:

SELECT 
	T0.ItemCode
	, T0.ItemName
	, T0.InvntryUom
	, T0.OnHand
	, T0.IsCommited as 'Comprometido'
	, T0.OnOrder as 'Solicitado'
	, (T0.OnHand - T0.IsCommited) as 'Faltante' 
FROM 
	OITM T0 
WHERE
	(T0.[IsCommited] > (0 ) )
	AND (T0.OnHand - T0.IsCommited) < 0

Saludos