On my Detailed Sales reports, when showing the columns: Qty Sold, Sold Price, Total Sales, Cost and Profit; the Cost & Profit columns do not calculate properly.
It appears that the Cost and Profit columns are not Extended by Qty Sold, resulting in inaccuracies wherever Qty Sold 1. This applies to both returns (negative Qty Sold) and sales where Qty Sold is 2 or more.
Total Sales does calculate properly (Qty Sold * Sold Price).
The end result is a report that has practically no value other than showing Total Sales.
Yes, the Department Cost/Sales report does provide an accurate picture of similar data, but with no detail--cannot be sorted by Supplier, for example, and doesn't show line item detail like the Detailed Sales Report does.
Tom