1
2
3
4
5
6
7
8
9
10
11
12
13
14
-- Análise de Faturamento por Produto · NTCode
SELECT
B1.B1_COD AS Produto, B1.B1_DESC AS Descricao,
SUM(D2.D2_QUANT) AS Qtd_Vendida, SUM(D2.D2_TOTAL) AS Faturamento,
B2.B2_QATU AS Saldo_Atual
FROM SD2010 SD2
INNER JOIN SB1010 SB1 ON SB1.B1_COD = SD2.D2_COD AND SB1.D_E_L_E_T_ = ' '
INNER JOIN SF2010 SF2 ON SF2.F2_DOC = SD2.D2_DOC AND SF2.F2_SERIE = SD2.D2_SERIE AND SF2.D_E_L_E_T_ = ' '
LEFT JOIN SB2010 SB2 ON SB2.B2_COD = SB1.B1_COD AND SB2.B2_LOCAL = '01'AND SB2.D_E_L_E_T_ = ' '
WHERE SD2.D_E_L_E_T_ = ' '
AND SF2.F2_EMISSAO BETWEEN '20240101' AND '20241231' AND SF2.F2_TIPO = 'N'
GROUP BY B1.B1_COD, B1.B1_DESC, B2.B2_QATU
ORDER BY Faturamento DESC