Discussions
Join the NetSuite community to innovate, connect, and discover what’s next.
SuiteWorld brings thousands of innovators, builders, and leaders together to learn, connect, and shape what’s next. This October, explore how to build a stronger foundation for growth through inspiring keynotes, major product reveals, hands-on sessions, and unforgettable moments—all in one place for our biggest event of the year. Register now
Customer Profitability Summary Report and Shipping Cost
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?