Veja se essa consulta lhe ajuda.
SELECT TMOV.NUMEROMOV,
TPRD.CODIGOPRD AS PROD,
(SUM(TITMMOV.QUANTIDADE))AS QUANT,
SUM(((100-ISNULL(TMOV.PERCENTUALDESC,0.0))/100)*((100+ISNULL(TMOV.PERCENTUALDESP,0.0))/100)*((100+ISNULL(TMOV.PERCENTUALFRETE,0.0))/100)
*((100+ISNULL(TMOV.PERCENTUALSEGURO,0.0))/100)*(TITMMOV.QUANTIDADE*TITMMOV.PRECOUNITARIO))AS VALTOTAL,
TITMMOV.CODUND
FROM TMOV (NOLOCK)
INNER JOIN TITMMOV (NOLOCK) ON TITMMOV.CODCOLIGADA=TMOV.CODCOLIGADA AND TITMMOV.IDMOV=TMOV.IDMOV
INNER JOIN GFILIAL (NOLOCK) ON GFILIAL.CODCOLIGADA=TMOV.CODCOLIGADA AND GFILIAL.CODFILIAL=(CASE WHEN TMOV.CODTMV LIKE '3.1%' THEN TMOV.CODFILIALDESTINO ELSE TMOV.CODFILIAL END)
INNER JOIN TPRD (NOLOCK) ON TPRD.CODCOLIGADA=TITMMOV.CODCOLIGADA AND TPRD.IDPRD=TITMMOV.IDPRD
WHERE TMOV.CODCOLIGADA=(:ESPELHO#1_S) AND
TMOV.STATUS<>'C' AND
TMOV.DATAMOVIMENTO BETWEEN (CONVERT(DATETIME, (:ESPELHO#2_D), 103)) AND ( CONVERT(DATETIME, (:ESPELHO#3_D), 103))
GROUP BY TPRD.CODIGOPRD,TITMMOV.CODUND,TMOV.CODTMV,TMOV.NUMEROMOV
ORDER BY PROD