Author Topic: Revenue Report Bug  (Read 1862 times)

teobgeno

  • Jr. Member
  • **
  • Posts: 55
    • www.netpin.gr
Revenue Report Bug
« 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

simbus82

  • Jr. Member
  • **
  • Posts: 109
    • Simbus82 Web & Tech
Re: Revenue Report Bug
« Reply #1 on: April 19, 2012, 19:46:48 pm »
i have open a similar post days ago... it is not resolved in 2.0.6
Joomla! 2.5.16 & VM 2.0.24b

teobgeno

  • Jr. Member
  • **
  • Posts: 55
    • www.netpin.gr
Re: Revenue Report Bug
« Reply #2 on: April 23, 2012, 16:56:59 pm »
virtuemat team please consider this for your next release.

Milbo

  • Virtuemart Projectleader
  • Administrator
  • Super Hero
  • *
  • Posts: 10070
  • VM3.2 Cached and Optimized
    • VM3 Extensions
  • VirtueMart Version: VirtueMart 3 on joomla 3
Re: Revenue Report Bug
« Reply #3 on: April 24, 2012, 23:37:26 pm »
added
I should fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

lejeannotfr

  • Jr. Member
  • **
  • Posts: 59
Re: Revenue Report Bug
« Reply #4 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.