Hello SAP Gurus!!
Can someone please help me complete this query from ORIN & RIN1 with the following information added:
A/R Credit Memo
I need actual Team Wise Sales Query after sales return Invoice.
Here is the my A/R Invoice Sale Analaysics Team Wise Query:
SELECT
T2.[SlpCode] AS "Team Code", T2.[SlpName] AS "Team Name", SUM(ISNULL(T1.GrssProfit,0))/SUM(ISNULL(T1.LineTotal,1) )*100 As "% GP", SUM (T1.GTotal) AS "Gross Sales ( +IVA )", SUM (T1.LineTotal) AS 'Net Sales ( -IVA )', SUM (T1.LineVat) AS "IVA Value", SUM ( ( T1.LineVat)/ ( T1.LineTotal)) As "% IVA", SUM (T3.GTotal) AS "Gross Sale Return", SUM (T3.LineTotal) AS "Net Sale Return", SUM (T3.VatSum) AS "IVA Return", SUM (T1.GPTtlBasPr) AS "Stocks Value", COUNT(T1.LineTotal) AS 'Sale In SKU', SUM (T1.quantity) AS 'Sale In Qty',SUM (T1.Weight1) AS "Sale In KG", SUM (T1.Volume) AS "Sale In Mtr" , SUM (T1.GrssProfit) AS "Gross Profit",SUM (T0.DiscSum) AS "Discount",SUM ( ( T1.GTotal - T1.LineVat)* ( T2.Commission/100)) As "Commissions"
FROM
OINV T0 INNER JOIN INV1 T1 ON T0.[DocEntry] = T1.[DocEntry]
INNER JOIN OSLP T2 ON T0.SlpCode = T2.SlpCode
LEFT OUTER JOIN RIN1 T3 ON T1.DocEntry = T3.BaseEntry
WHERE
T1.DocDate BETWEEN [%1] and [%2]
GROUP BY
T2.[SlpCode], T2.[SlpName]
Regards,
Mohammad Firoz