Hello SAP Gurus!!
Can someone please help me complete this query with the following information added:
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.