Author Topic: About price rounding  (Read 303 times)

jabba

  • Beginner
  • *
  • Posts: 29
    • Pixed - Web Store Assistance
About price rounding
« on: March 15, 2018, 09:59:48 am »
Hello! I need help to configure my virtuemart in order not to have problems with VAT roundings.
Please take a look at the attachment.

The table headers are: SKU, Name, Price WITH VAT, Price WITHOUT VAT, Q.ty, VAT, TOTAL

I have, in the first row, Oranges that costs 1.43+4% VAT --> 1,4872€ --> rounded to 1,49€

But 1,49 * 8 --> 11.92€ (but there i have 11.90€)

That's because the multiply is 1,4872€ * 8 = 11,8976 --> rounded to 11,90€

In the 2nd attachment you will find my prices configuration. How can i set it to avoid this problems?
Thank you!

EDIT: joomla version 3.8.5 -- virtuemart version 3.2.12 -- PHP 7.0.11
Gianluca Gabella - CEO & Web Developer @ Pixed s.n.c.b - www.pixed.it

jabba

  • Beginner
  • *
  • Posts: 29
    • Pixed - Web Store Assistance
Re: About price rounding
« Reply #1 on: March 16, 2018, 12:21:48 pm »
Hello! I was trying some experiments.
Deselecting "round on video only" i get the right prices but VAT are completly wrong: please see the screen.

Is there a way to round VAT without decimals?
Thank you

Gianluca Gabella - CEO & Web Developer @ Pixed s.n.c.b - www.pixed.it

lausianne

  • Beginner
  • *
  • Posts: 34
Re: About price rounding
« Reply #2 on: March 28, 2018, 09:29:25 am »
Have you been able to find a solution yet?
It may be related to my issue here: https://forum.virtuemart.net/index.php?topic=139642.msg491349#msg491349
... still looking for a solution there.

jabba

  • Beginner
  • *
  • Posts: 29
    • Pixed - Web Store Assistance
Re: About price rounding
« Reply #3 on: March 28, 2018, 09:31:22 am »
Hello, i've solved using a commercial extension to generate invoices (i don't know if i can link it here). That extension let you choose how many decimals VATs can have.
Bye.
Gianluca Gabella - CEO & Web Developer @ Pixed s.n.c.b - www.pixed.it

lausianne

  • Beginner
  • *
  • Posts: 34
Re: About price rounding
« Reply #4 on: April 03, 2018, 16:12:31 pm »
Thanks for your reply. Why would you not be allowed to link to an extension? I'd appreciate if you did.

jabba

  • Beginner
  • *
  • Posts: 29
    • Pixed - Web Store Assistance
Re: About price rounding
« Reply #5 on: April 03, 2018, 16:23:57 pm »
i don't know if I can advertise extensions... anyway it's this one: https://www.artio.net/virtuemart-tools/vm-invoice-generator (moderator will remove the link if not permitted :) )
It's not just a PDF generator.. you can edit orders and lot of stuff with this extension.
Bye
Gianluca Gabella - CEO & Web Developer @ Pixed s.n.c.b - www.pixed.it

lausianne

  • Beginner
  • *
  • Posts: 34
Re: About price rounding
« Reply #6 on: April 05, 2018, 20:03:37 pm »
I got the extension, works well. Thanks, jabba!