Currently, the Customer Sales History Report By Period does not account for invoice discounts in the calculation of gross profit. For example, if you have a customer that has 1 invoice for $100 in sales and $50 in cost of sales and a invoice discount of 15% or $15, then the report shows sales of $100, cost of sales of $50 and a gross profit of $50. I would like the invoice discounts to reduce sales so I would prefer that the sales show as $85 ($100 gross sales - $15 in discounts), cost of sales of $50 and a gross profit of $35 = ($85 in sales - $50 cost of sales). Thank you for voting for this idea!
by: Tyler C. | over a year ago | Reports / BI
Comments
Easy one to do and it makes a lot of sense!
This idea is unnecessary. Further testing shows that the current report is calculating the gross profit correctly.