SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[paQrytm_KdexGBod] @pmtmNumero VARCHAR(5)
 AS
SELECT tmIdProducto,DescripProd,ExtciaAct,tmIdBodega,SUM(tmEntradas) AS SENT,SUM(tmSalidas) AS SSAL
,SUM(tmEntradas*tmVrUnitario) AS SCOSENT,SUM(tmSalidas*tmVrUnitario) AS SCOSSAL
--entradas con flete al costo
,SUM(tmEntradas*(tmVrUnitario+tmNumInicial)) AS SCOSENTFLE
,SUM(tmSalidas*(tmVrUnitario+tmNumInicial)) AS SCOSSALFLE
 FROM tm_Kdex AS K INNER JOIN ProdMcias AS P ON K.tmIdProducto=P.IdProducto
 WHERE tmNumero=@pmtmNumero AND TipoRef<>'SERVICIO'
 GROUP BY  tmIdProducto,DescripProd,ExtciaAct,tmIdBodega 
 ORDER BY tmIdProducto,tmIdBodega
GO

SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO