VirtueMart Forum

VirtueMart 2 + 3 => Virtuemart Development and bug reports => Topic started by: teobgeno on April 19, 2012, 19:24:21 pm

Title: Revenue Report Bug
Post by: teobgeno on April 19, 2012, 19:24:21 pm
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]
$selectFields[] = 'SUM(product_final_price) as order_subtotal';

With this

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


Also replace

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


With this

Code: [Select]
$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
Title: Re: Revenue Report Bug
Post by: simbus82 on April 19, 2012, 19:46:48 pm
i have open a similar post days ago... it is not resolved in 2.0.6
Title: Re: Revenue Report Bug
Post by: teobgeno on April 23, 2012, 16:56:59 pm
virtuemat team please consider this for your next release.
Title: Re: Revenue Report Bug
Post by: Milbo on April 24, 2012, 23:37:26 pm
added
Title: Re: Revenue Report Bug
Post by: lejeannotfr on March 02, 2013, 16:28:29 pm
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.