Subtotal amount appears wrong at the Checkout

[Lite82]

Hello everybody,

I have an issue with the subtotal and total amount shown at the checkout process when using the currency as GBP (The Webshop is set in Euro but the customer has the option to change currency into GBP and we have noticed that this issue is not happening when using Euro).

-During the checkout, at steps 1 to 3 (choosing shipping address, shipping method, payment method) the subtotal, tax and total amount are correct.

-At step 4 (check_out_get_final_confirmation) the quantity, product name, id number is shown correct BUT THE SUBTOTAL IS WRONG. the taxes are right(acording to the right amount) and THE TOTAL IS WRONG AGAIN (because it takes the same subtotal).

  This is the last step before making the payment. If Paypal is choosen, it sometimes gets the amount shown at the step 4 (which is wrong!) or the one at step 3 (which is the good one BUT increasing it by 1-3 cents. I guess this is related to the round function used at the PayPAl configuration. I tried to just take it out but it did not work)
      
-I have also noticed that on the email confirmation sent to the customer (purchase order email, created from the confirmation_email.tpl.php) the subtotal appears correct  but the total ($order_total) is incorrect.

The difference between the amount that is shown and the amount that it should appear is less than one pound. Sometimes the correct price should be higher, others it should be less.
 
I am not using any coupon component. The subtotal already includes VAT/Taxes.

So this is what happens:

checkout_stage=3 (CHECK_OUT_GET_FINAL_CONFIRMATION)

quantity 100 price per product £2,91 

Subtotal: £291,00
Subtotal: £291,00
Shipping: £0,00 (Free)
VAT/TAX:  £46,39
Total   : £291,00


checkout_stage=3 (CHECK_OUT_GET_FINAL_CONFIRMATION)

quantity 100 price per product £2,91 Subtotal: £290,56

Subtotal: £290,56
Shipping: £0,00 (Free)
VAT/TAX:  £46,39
Total   : £290,56


IN THE PURCHASE ORDER CONFIRMATION EMAIL:

quantity 100 price per product £2,91 subtotal: £291,00

Subtotal:  £291,00
Shipping:  £0,00 (Free)
VAT/TAX:   £46,39
Total:     £290,93


It seems to me that ps_checkout.php has the information needed the checkout and the confirmation_email so I dont get why it appears different at differentt steps of the process.

Can it just be a problem related with rounding the quantities? I prefer not to set a fixed currency for GBP (righ now the convertECB.php is used which sets the currency at daily.xml) but maybe using just 2 decimals for the currency would solve the issue?

Any idea of how can it be solved? This is seriously driving me crazy. Any help would be highly appreciated!!! Happy Easter btw 

For reference, Im using:

Virtuemart 1.1.9
Joomla 1.5.25

Thanks in advance!

Marķa.

[MrAtari]

I'm having a similar problem, but mine is calculated in Euro's

Virtuemart comes with this checkout:
                      220 * 0,79 = 173,80 (correct)
                                    fee      2,00
Shipping and handling          15,90
                             19%tax    28,22 (incorrect)
                     Total amount 192,17 (incorrect)

When it calculates with the price with tax included it should be: 173,80/1,19=146,05 -> tax is 27,75
Even when I add the fee to this price it should be: (173,80+2,00)/1,19=147,73 -> tax is 28,06
This is the closest I get to the calculation VM makes. Still there is a difference from 16 cents.

The correct calculation is this one:
                      220 * 0,79 = 173,80 (correct)
                                    fee      2,00
Shipping and handling          15,90
                             19%tax    36,42
                     Total amount  228,12

The tax rate is in the administration: country NL, tax 0.19000)
There is also a tax rate from 6% (country NL, tax 0.06000)

In tax configuration: virtual tax: "on" / mode "based on shop address" / use multiple tax "on" / reduction before shipping "on"

Is there a bug in the calculation or do I have to alter a setting?