Weighted average Discount Percentage on Sales Order Detail report
On behalf of harold@xixspirit.com
1) can you fix the report so that the % discount is calculated on a weighted average method
2) Can you fix the report so that it shows every line in a sales order
Eg:
We sold 42 bottles of our whisky to a customer at full price, and add an extra line with the same whisky at 100% discount. The Sales Order Detail report shows that we sold 43 bottles at 50% discount.
The numbers should look like:
43 bottles with a 2.38% discount