Skip to Content
0
Jun 10, 2016 at 10:13 PM

Monthly Sales Employee Analysis

33 Views

Hello SAP Gurus!!

Can someone please help me complete this query with the following information added:

Gross Profit

Gross %

Totals at the bottom of Query

and also I need the Query to list Invoices that have been Paid only.

Here is the Query:

SELECT 'Invoice' "Invoice/AR Credit Memo", T0.CardCode "BP Code", T0.CardCode "Cust Name", T0.DocDate,T0.DocNum, T0.DocTotal "Gross Amt", T0.TotalExpns "Freight/Svc Charge", (T0.DocTotal - T0.VatSum-T0.TotalExpns) "Net Order", T1.SlpName "Sales Rep"

FROM [dbo].[OINV] T0 INNER JOIN [dbo].[OSLP] T1 ON T0.SlpCode = T1.SlpCode

WHERE T1.SlpName like '[%0]%' AND (T0.DocDate BETWEEN '[%1]' AND '[%2]')

Thank you in advance for your help.

Kind regards,

Larry T.