Sales analysis report query

Hello,

Can you help me get a sales report by item that gives me the exact same result as the standard sales analysis report. Including OINV, ORIN, ODPI and the discounts made in these documents.

I have this query but it gives me a small difference

SELECT

T1.[ItemCode], Case When T0.DiscPrcnt = 0 then T1.LineTotal else (T1.linetotal*T0.DiscPrcnt/100) END

FROM OINV T0 INNER JOIN INV1 T1 ON T0.[DocEntry] = T1.[DocEntry] INNER JOIN OSLP T2 ON T0.[SlpCode] = T2.[SlpCode] left outer JOIN OITM T3 ON T1.[ItemCode] = T3.[ItemCode]

Where t0.canceled='n'

UNION ALL

SELECT T1.[ItemCode], Case When T0.DiscPrcnt = 0 then T1.LineTotal*-1 else (T1.linetotal*-1)*(T0.DiscPrcnt/100) END

FROM ORIN T0 INNER JOIN RIN1 T1 ON T0.[DocEntry] = T1.[DocEntry] INNER JOIN OSLP T2 ON T0.[SlpCode] = T2.[SlpCode] left outer JOIN OITM T3 ON T1.[ItemCode] = T3.[ItemCode]

Where t0.canceled='n'

UNION ALL

SELECT T1.[ItemCode], Case When T0.DiscPrcnt = 0 then T1.LineTotal else (T1.linetotal*T0.DiscPrcnt/100) END

FROM ODPI T0 INNER JOIN DPI1 T1 ON T0.[DocEntry] = T1.[DocEntry] INNER JOIN OSLP T2 ON T0.[SlpCode] = T2.[SlpCode] left outer JOIN OITM T3 ON T1.[ItemCode] = T3.[ItemCode]

Where t0.canceled='n'

Thanks