News:

Support the VirtueMart project and become a member

Main Menu

Discounted price round on multiple items

Started by JM0308, November 08, 2017, 10:58:43 AM

Previous topic - Next topic

JM0308

Hi
We have come across an issue with the taxes and calculations rules of apply a discount of 20%.

If a customer buys 1 item at £6.16 with a discount of 20% it comes out at £4.93. Discount of £1.23. This is correct per item.
If a customer buys 4 items at £6.16 with a discount of 20% it comes out at £19.71. Discount of £4.93. This is incorrect, is should be £4.92. What it has done is 4 x £6.16 = £24.64 then applied 20% discount which is £19.71.
What it should be doing is 4 x the discounted price of £4.93 = £19.72 rather than discounting the total net price it needs to discount the individual item price then times it by 4.

I have been looking through the config and tax calculation rules but none of them seem to work?

Any ideas?

VirtueMart 3.2.4
Joomla! 3.8.1

alexanderflr

I would like to know how to change that as well,  I have issues with the pricing because of that. The price doesn't match anymore with the data from our ERP software and our accountant is to lazy to do the adjustments.
VM 3.2.8, Joomla 3.8.3, PHP 7.0.26

AH

Jm0308

QuoteIf a customer buys 1 item at £6.16 with a discount of 20% it comes out at £4.93. Discount of £1.23. This is correct per item.
If a customer buys 4 items at £6.16 with a discount of 20% it comes out at £19.71. Discount of £4.93. This is incorrect, is should be £4.92. What it has done is 4 x £6.16 = £24.64 then applied 20% discount which is £19.71.
What it should be doing is 4 x the discounted price of £4.93 = £19.72 rather than discounting the total net price it needs to discount the individual item price then times it by 4.

Review your calculations and consider each step.  VM does not round each step in the process

The single Item price with discount = 6.16 * .8  = 4.928   

A line item of qty = 1 = 1 * 4.928 = 4.928 rounded to 2dp = 4.93
A line item of qty = 4 = 4 * 4.928 = 19.712 rounded to 2dp = 19.71

alexanderflr
QuoteThe price doesn't match anymore with the data from our ERP software and our accountant is to lazy to do the adjustments.

Maybe you can get the accountant to consider how discount works in his ERP system calculations   - the price per item should have more than 2 decimal places in any ERP or accounting system. 
Regards
A

Joomla 4.4.5
php 8.1