Report by BP, by Group, by Salesperson

[Former Member]

Good morning

is there a report that will give the sales by BP, GROUP and by SALEPERSON

Thank you

[Former Member]

This report might be better done by XL Reporter with good format.

Thanks,

Gordon

[Former Member]

Or you can run this Query:

SELECT T3.MailCounty, T4.FirmName,T5.SlpName, t0.docnum, T1.ItemCode, T1.Dscription, T1.Quantity,T1.LineTotal, CONVERT(nchar(8), T0.DocDate, 112) AS DATE,T1.ShipDate, T0.CardCode, T0.CardName, T0.DocDate FROM OINV T0 INNER JOIN INV1 T1 ON T0.DocEntry = T1.DocEntry INNER JOIN OITM T2 ON T1.ItemCode = T2.ItemCode INNER JOIN OCRD T3 ON T0.CardCode = T3.CardCode INNER JOIN OMRC T4 ON T2.FirmCode = T4.FirmCode INNER JOIN OSLP T5 ON T1.SlpCode = T5.SlpCode WHERE CONVERT(nchar(8), T0.DocDate, 112) >= [%2] AND CONVERT(nchar(8), T0.DocDate, 112) <= [%3] AND (T5.SlpName Like '%[%4] %'

OR T5.SlpName LIKE '[%4]%'

OR T5.SlpName LIKE '%[%4]')

union

SELECT T3.MailCounty, T4.FirmName,T5.SlpName, t0.docnum, T1.ItemCode, T1.Dscription, T1.Quantity,T1.LineTotal * -1, CONVERT(nchar(8), T0.DocDate, 112) AS DATE,T1.ShipDate, T0.CardCode, T0.CardName, T0.DocDate FROM ORIN T0 INNER JOIN RIN1 T1 ON T0.DocEntry = T1.DocEntry INNER JOIN OITM T2 ON T1.ItemCode = T2.ItemCode INNER JOIN OCRD T3 ON T0.CardCode = T3.CardCode INNER JOIN OMRC T4 ON T2.FirmCode = T4.FirmCode INNER JOIN OSLP T5 ON T1.SlpCode = T5.SlpCode WHERE CONVERT(nchar(8), T0.DocDate, 112) >= [%2] AND CONVERT(nchar(8), T0.DocDate, 112) <= [%3] AND (T5.SlpName Like '%[%4] %'

OR T5.SlpName LIKE '[%4]%'

OR T5.SlpName LIKE '%[%4]')

ORDER BY T5.SlpName,T4.FirmName, T1.Dscription

[Former Member]

Yes...but the secondary selection only comes to you under the items, so this a detailled by ITEM, they would like it by BP by GROUP by SALESPERSON

[msundararaja_perumal]

Hi,

Default report is available under Sales->Sales Analysis

Where you can view the sales by BP,Group and Sales Employee wise.