Hola a todos quisiera saber si akguine ha hecho u query con el kardex he hecho uno pero quisera que alguien me lo validara saludos,
(Isnull(t2.OnHand,0.000)-Isnull(t3.Movto,0.000)) as Saldo,
Isnull(t6.entrada,0.000) as Compras,
Isnull(t7.Entradas,0.000) as ‘Entradas x Ajustes’,
Isnull(t8.Entradas,0.000) as ‘Traslados +’,
isnull(t9.CONSUMIDO,0.00) as ‘Venta’,
isnull(t10.salidas,0.00) as ‘Requisicion’,
isnull(t11.salidas,0.00) as ‘Salidas x Ajuste’,
isnull(t12.salidas,0.00) as ‘Desechos’,
isnull(t13.salidas,0.000) as ‘Traslados -’,