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]

Phone: 888.239.2818 | Fax: 312.621.9200

 Copyright © 2012 Clients First Business Solutions (North America) LLC. All rights reserved

CFBS Locations: New Jersey (Head Office)Alabama | California | FloridaIllinois | Minnesota | TennesseeTexas