Skip to Content
0
Jun 21, 2020 at 03:06 AM

Team & Each Category Wise Sales Query after sales return Invoice.

49 Views

Hello SAP Gurus!!

Can someone please help me complete this query from ORIN & RIN1 with the following information added:

A/R Credit Memo

  1. Actual Gross Sale after Sales Return
  2. Actual Net Sale after Ssales Return
  3. Actual VAT Sale After Sales Return
  4. Each Category Wise Gross Sale

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