50-times-faster-1.sql

SELECT
	<...>
	
	CASE
		WHEN ENDOFPERIOD(Inventory.SalesDocument.Date, MONTH) < ENDOFPERIOD(Inventory.Period, MONTH)
			THEN TRUE
		ELSE FALSE
	END AS ItsReturnOfLastPeriod,
	
INTO TTReturns

FROM
	AccumulationRegister.Inventory AS Inventory
	
WHERE
	CASE
		WHEN &Ref = UNDEFINED
			THEN Inventory.Period BETWEEN &BeginOfPeriod AND &EndOfPeriod
		ELSE Inventory.Recorder = &Ref
	END
	AND	(
			NOT Inventory.FixedCost
			OR ENDOFPERIOD(Inventory.SalesDocument.Date, MONTH) < ENDOFPERIOD(Inventory.Period, MONTH)
			AND Inventory.FixedCost
	)
	AND Inventory.Return
	AND Inventory.Entity = &Entity
	AND Inventory.CorrGLAccount_GL = &EmptyAccount_GL
	AND Inventory.SalesDocument <> UNDEFINED

GROUP BY
	<...>
	
	CASE
		WHEN ENDOFPERIOD(Inventory.SalesDocument.Date, MONTH) < ENDOFPERIOD(Inventory.Period, MONTH)
			THEN TRUE
		ELSE FALSE
	END