Stored Procedure in SQL Server - Venta Neta Acumulada

Procedimiento almacenado en SQL SERVER  con el cual se obtiene La Venta Neta Acumulada

	--BD de SAP Business One 9.3
	--TABLA OINV es la Tabla Factura de Deudores
	--TABLA ORIN es la Tabla Nota de crédito de clientes
	/*
	Procedimiento Almacenado
	Para obtener: La Venta Neta Acumulada
	*/
	CREATE PROCEDURE [dbo].[SBO_Ejemplo_X]
	as
	BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;
	select DocDate as 'Fecha',sum(doctotal) as 'Importe Pesos',sum( doctotalfc) as 'Importe USD',max( doccur) as 'Moneda',max(docrate) as 'TC', YEAR(DocDate) as 'Año',MONTH(docdate) as 'Mes'
	from oinv
	where CANCELED = 'N' and CardCode<>'C118' and DocType <> 'S'
	group by docdate
	union
	select DocDate,sum(doctotal*-1),sum( doctotalfc*-1),max( doccur),max(docrate), YEAR(DocDate),MONTH(docdate)
	from orin
	where CANCELED = 'N' and CardCode<>'C118'
	group by docdate
	END
	GO
	--exec SBO_Ejemplo_X

https://github.com/Support-MC/Stored-Procedure-SAP-B1