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