Author Topic: Revenue report only shows gross revenue in VM 3.2.2 (and 3.2.4)  (Read 624 times)

avkeele

  • Beginner
  • *
  • Posts: 48
The revenue report has net revenues, gross revenues, and discounts applied.

However it is calculating net revenues = gross revenues, even though discounts are listed in the discount column. This means that my net revenues are not available unless I calculate manually, which defeats the purpose of a revenue report.

Please advise. Using VM 3.2.2 on Joomla 3.7.4 with PHP 7.0.

Regards,
Allen

avkeele

  • Beginner
  • *
  • Posts: 48
Re: Revenue report only shows gross revenue in VM 3.2.2
« Reply #1 on: August 12, 2017, 20:37:38 pm »
Bump.

jenkinhill

  • UK Web Developer & Consultant
  • Global Moderator
  • Super Hero
  • *
  • Posts: 26428
  • Always on vacation
    • Jenkin Hill Internet
Kelvyn

Jenkin Hill Internet,
Lowestoft, Suffolk, UK

Unsolicited PMs/emails will be ignored.

Please mention your VirtueMart, Joomla and PHP versions when asking a question in this forum

Currently using VM3.2.10 on Joomla 3.8.3 PHP 7.0.25

Testing VM3.2.10.9700 on J3.8.3

avkeele

  • Beginner
  • *
  • Posts: 48
Re: Revenue report only shows gross revenue in VM 3.2.2
« Reply #3 on: August 20, 2017, 17:52:46 pm »
Any advice?

Regards,
Allen

Milbo

  • Virtuemart Projectleader
  • Administrator
  • Super Hero
  • *
  • Posts: 9416
  • VM3.2 Cached and Optimized
    • VM3 Extensions
  • VirtueMart Version: VirtueMart 3 on joomla 3
Re: Revenue report only shows gross revenue in VM 3.2.2
« Reply #4 on: August 22, 2017, 20:19:04 pm »
Did you test with the last version?

I should fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

avkeele

  • Beginner
  • *
  • Posts: 48
Re: Revenue report only shows gross revenue in VM 3.2.2
« Reply #5 on: August 23, 2017, 04:48:47 am »
Hello,

Thanks for your reply.

3.2.2 is the latest stable version as maintained by VM's Joomla update, and what is available at https://virtuemart.net/downloads. I did not test with previous versions since we only started offering discount coupons with this version.

Milbo

  • Virtuemart Projectleader
  • Administrator
  • Super Hero
  • *
  • Posts: 9416
  • VM3.2 Cached and Optimized
    • VM3 Extensions
  • VirtueMart Version: VirtueMart 3 on joomla 3
I should fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

avkeele

  • Beginner
  • *
  • Posts: 48
Re: Revenue report only shows gross revenue in VM 3.2.2
« Reply #7 on: August 31, 2017, 06:11:22 am »
I now have 3.2.4, and the problem still exists. See the screen capture.

BTW - off lesser concern is the need to align formatting properly.

Thanks,
Allen

Milbo

  • Virtuemart Projectleader
  • Administrator
  • Super Hero
  • *
  • Posts: 9416
  • VM3.2 Cached and Optimized
    • VM3 Extensions
  • VirtueMart Version: VirtueMart 3 on joomla 3
Re: Revenue report only shows gross revenue in VM 3.2.2 (and 3.2.4)
« Reply #8 on: September 04, 2017, 13:31:30 pm »
Yepp, the coupons. At least I added them, so that you see that coupons were used. There are two problems. First, when you use the revenue report per product, no coupon can be assigned to certain products. It could be assigned, when there is only one product on the invoice. So the coupon stuff do not work with the list per product.
Furthermore coupons are differently used. Sometimes like a discount, but sometimes like a currency.
I should fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

avkeele

  • Beginner
  • *
  • Posts: 48
Re: Revenue report only shows gross revenue in VM 3.2.2 (and 3.2.4)
« Reply #9 on: September 04, 2017, 14:23:24 pm »
Hello,

I'm sorry, I do not understand your reply. Perhaps you could clarify? Are you saying that what I am describing is a known issue?

The report screen capture I provided was not per product, it was simply orders in a designated period.

Regards,
Allen

avkeele

  • Beginner
  • *
  • Posts: 48
Re: Revenue report only shows gross revenue in VM 3.2.2 (and 3.2.4)
« Reply #10 on: September 24, 2017, 16:31:29 pm »
Bump.  :o

GJC Web Design

  • 3rd party VirtueMart Developer
  • Super Hero
  • *
  • Posts: 7655
  • Virtuemart, Joomla & php developer
    • GJC Web Design
  • VirtueMart Version: 2.6.22 & 3.2.2
Re: Revenue report only shows gross revenue in VM 3.2.2 (and 3.2.4)
« Reply #11 on: September 24, 2017, 17:14:22 pm »
Max is saying it isn't easy in a logical sense to split up coupons over ind. order items etc..

There are much more comprehensive 3rd party report tools available
We have used this for clients ..  http://analytictools.latitudweb.com/
GJC Web Design
VirtueMart and Joomla Developers - php developers http://www.gjcwebdesign.com
VM3 AusPost Shipping Plugin - e-go Shipping Plugin - VM3 Postcode Shipping Plugin - Radius Shipping Plugin - VM3 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
http://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

avkeele

  • Beginner
  • *
  • Posts: 48
Re: Revenue report only shows gross revenue in VM 3.2.2 (and 3.2.4)
« Reply #12 on: September 26, 2017, 15:59:45 pm »
Ah. Thanks.

Strange that the revenue report has a "gross" column" and a "net" column if it can't even subtract coupons as well as the invoices can - even with order aggregate totals. I'll look into the third party tool you recommended.

GJC Web Design

  • 3rd party VirtueMart Developer
  • Super Hero
  • *
  • Posts: 7655
  • Virtuemart, Joomla & php developer
    • GJC Web Design
  • VirtueMart Version: 2.6.22 & 3.2.2
Re: Revenue report only shows gross revenue in VM 3.2.2 (and 3.2.4)
« Reply #13 on: September 26, 2017, 23:18:00 pm »
This is free software...  there are a 1000 & 1 things that could be done, improved, changed, developed.. it is a matter of resources, priorities and time
There is a membership system to get things done to the core if you want them done quickly
GJC Web Design
VirtueMart and Joomla Developers - php developers http://www.gjcwebdesign.com
VM3 AusPost Shipping Plugin - e-go Shipping Plugin - VM3 Postcode Shipping Plugin - Radius Shipping Plugin - VM3 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
http://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation