We have a cart discount of 10% - which all works fine
the generated invoice and screens all show discount, shipping, tax and total amount correctly
But when doing a sales manual export spreedsheet report the product amount normally shows the product figure (Subtotal column ) without tax
In our example the original Price is 79.95 inc tax and the tax is 10%
As we have applied a 10% discount the product amount is now $8 less $71.95
In the sreedsheet this should be shown without tax as 65.41 but it is showing as 64.68
which is .73 less -> this .73 is the amount of tax on the discount amount of $8 which has already been applied
Clearly a bug!.
Any ideas of the files/lines of code to fix it. Thanks for any help or guidance
Running magento CE 1.9.2.4