Revenue Report Bug

[teobgeno]

joomla 1.5.26 VM 2.0.4
At revenue report the Revenue column total amount is incorrect .

1 ) The total sum is the add of the product(s) (product_final_price) of the order(s) . But in this sum the quantity of each sold product is not calculated .So if i have in my order item Y (x2) with price 100.The total sum at revenue must be 200 but instead is 100.

2)At order column the sum of the orders is not correct.

At administrator/components/com_virtuemart/models/report.php i made the modifications below

Replace the line below

Code Select Expand


$selectFields[] = 'SUM(product_final_price) as order_subtotal';


With this

Code Select Expand


$selectFields[] = 'SUM(product_subtotal_with_tax) as order_subtotal';



Also replace

Code Select Expand


$selectFields[] = 'COUNT(o.virtuemart_order_id) as count_order_id';



With this

Code Select Expand


$selectFields[] = 'COUNT(DISTINCT o.virtuemart_order_id) as count_order_id';



As is i said this bug is on vm 2.0.4 . Because i have not tested it yet on 2.0.6 can anyone confirms that this is fixed on 2.0.6 ?
Thank you

[simbus82]

i have open a similar post days ago... it is not resolved in 2.0.6

[teobgeno]

virtuemat team please consider this for your next release.

[Milbo]

added

[lejeannotfr]

the other bug is that the total amout does not substract the amout of the discounts coupon used by customers. Example : a customer orders for $100, he applies a discount coupon for $10 the total amount of the order is $90 without shipping fees. But in the report, the total revenue indicated is $100... the discount is not substracted from the gran total.