Query de kardex


#1

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 -’,


#2

Para qué sistema es esto? Versión y base de datos?

Por favor, recuerda pasar por #presentaciones para crear tu debate de presentación.

Saludos