Running the canned Customer Profitability Summary report gives a Total Revenue number by customer (as well as Total Cost and Profitability). When you click that very number for detail (by invoice), the sum revenue total of each invoice differs from the revenue total in the summary report because the summary includes shipping cost (actual shipping billed in the invoice) from each invoice and the detail report does not.
I would think including shipping in the Revenue total of the Summary Report provides a misleading profitbility amount if the actual "cost" of that shipping is not also included. In fact, is there a way to hold both the billable shipping and cost of shipping amounts in the same transaction?
In any event, does anyone know how to exclude shipping from the total revenue calcuation in the Summary Profitability report?
Thanks, Don