Profit margin
I am looking for a report that will help to calculate the overall profit margin on each customer. So far the best way I can see to do this is with a sales item detail report in which we have to manually calculate the cost of items sold, then use formulas in excel to find the profit margin. Is there an easier way? A report that does all the work for you would be nice.