SAP Business One query to retrieve the sales turnover by month

 SELECT 

    YEAR(T0.DocDate) AS 'Year',

    MONTH(T0.DocDate) AS 'Month',

    SUM(T1.LineTotal) AS 'Sales Turnover'

FROM 

    OINV T0 

    INNER JOIN INV1 T1 ON T0.DocEntry = T1.DocEntry 

WHERE 

    T0.DocStatus = 'C' 

    AND YEAR(T0.DocDate) = YEAR(GETDATE()) 

GROUP BY 

    YEAR(T0.DocDate), 

    MONTH(T0.DocDate)