SAP Business One Training Tips #4

Negative Gross Profit and Sales Report from A/R Credit Memos

SELECT T0.[DocDate], T4.[GroupName], T0.[CardCode], T0.[CardName], ((T1.[Quantity]* -100)/100) AS ‘Qty Returned’, (T1.[Price]*((T1.[Quantity]* -100)/100)) AS ‘Net Sales’, (T1.[PriceBefDi]*((T1.[Quantity]* -100)/100)) AS ‘Gross Sales’, T2.[SlpName]
FROM ORIN T0 INNER JOIN RIN1 T1 ON T0.DocEntry = T1.DocEntry
INNER JOIN OSLP T2 ON T1.SlpCode = T2.SlpCode
INNER JOIN OCRD T3 ON T0.CardCode = T3.CardCode
INNER JOIN OCRG T4 ON T3.GroupCode = T4.GroupCode
WHERE T0.[DocDate] >=[%0] AND T0.[DocDate] <=[%1] AND T1.[Quantity] >= 1
ORDER BY T4.[GroupName], T0.[CardName]

2019-01-16T11:22:42+00:00 March 16th, 2015|SAP Business One|Comments Off on SAP Business One Training Tips #4