SAP Business One query to retrieve the sales turnover by sales person

 SELECT 

    T0.SlpCode AS 'Sales Person Code', 

    T4.SlpName AS 'Sales Person Name',

    SUM(T1.LineTotal) AS 'Sales Turnover'

FROM 

    OINV T0 

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

    INNER JOIN OCRD T2 ON T0.CardCode = T2.CardCode 

    INNER JOIN OSLP T4 ON T0.SlpCode = T4.SlpCode 

WHERE 

    T0.DocStatus = 'O' 

    AND T0.DocDate >= '[%0]' 

    AND T0.DocDate <= '[%1]' 

GROUP BY 

    T0.SlpCode, 

    T4.SlpName