Total Revenue by Business Partner Including Freight

[Former Member]

I would like to see total revenue by BP for a specific date range that includes freight and credit memos.  I have been using the Sales Analysis function, but it does not include freight.

Thanks,

Gary

[Former Member]

We haul our own freight, so we include it as revenue and not an expense.  I was needing a query to show all revenue from a customer minus any credit memos.

Thanks,

Gary

[kothandaraman_nagarajan]

Try:

SELECT T0.[DocNum], T0.[DocDate], T0.[CardCode], T0.[CardName], T1.[ItemCode], T1.[Dscription], sum(T0.[DocTotal]) FROM OINV T0  INNER JOIN INV1 T1 ON T0.DocEntry = T1.DocEntry WHERE T0.[DocDate]  between [%0] and [%1]

group by

T0.[DocNum], T0.[DocDate], T0.[CardCode], T0.[CardName], T1.[ItemCode], T1.[Dscription]

union all

SELECT T0.[DocNum], T0.[DocDate], T0.[CardCode], T0.[CardName], T1.[ItemCode], T1.[Dscription], -sum(T0.[DocTotal]) FROM ORIN T0  INNER JOIN RIN1 T1 ON T0.DocEntry = T1.DocEntry WHERE T0.[DocDate]  between [%0] and [%1]

group by

T0.[DocNum], T0.[DocDate], T0.[CardCode], T0.[CardName], T1.[ItemCode], T1.[Dscription]

[kothandaraman_nagarajan]

Hi,

Freight is not part of sales analysis. It is an addtional cost incurred to ship customer items.

Thanks & Regards,

Nagarajan

[Former Member]

Hi,

You can check through the Ledger account of selected the Customer.

As per the standard Freight is not the revenue, because you are paying to someone else.

Regards,

Tausif