Skip to Content
avatar image
Former Member

Total Revenue by Business Partner Including Freight

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Jan 03, 2015 at 07:30 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 05, 2015 at 01:13 AM

    Hi,

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

    Thanks & Regards,

    Nagarajan

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 05, 2015 at 02:05 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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]