search-icon

Weighted average Discount Percentage on Sales Order Detail report

started a topic 26 days ago

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



Login or Signup to post a comment
Log in or Sign up to post a comment