Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email community@magento.com.

Magento Forum

1.6.0.0 price rounding issues, wrong price displayed on grid and product view
 
moncif
Jr. Member
 
Total Posts:  8
Joined:  2010-04-30
 

just upload the files of the attachment to the root where you installed magento. Just like installing a module. I have tested it on 1.6.2 and it works.

BTW: it works out of box smile. just empty the cach en stuff like that. Let me know if it does not work.

 
Magento Community Magento Community
Magento Community
Magento Community
 
ateetagrawal
Jr. Member
 
Total Posts:  8
Joined:  2011-08-08
 

Subtotal $328.95
Discount (coupontesting) -$49.34 (Discount : 15%)
Grand Total Excl. Tax $279.61
Tax $24.05 (8.6%)
Grand Total Incl. Tax $303.65

The GrandTotal has an error of 1 penny. It should be $303.64. Tried all the solutions but its not working.

Not sure why Magento has this penny issue and its not been rectified yet.

Using magento version 1.5

Please help here. Stuck badly here.

 
Magento Community Magento Community
Magento Community
Magento Community
 
Andrea_Magento
Jr. Member
 
Total Posts:  23
Joined:  2011-10-28
 

I’ve applied the extension…
1) now in my catalog I’ve the wrong price (39,91 euro)
2) if I click on the product, the price in the product form is ok
3) the checkout is ok
4) the wishlist shows the wrong price (39,91)
What I missed?

 
Magento Community Magento Community
Magento Community
Magento Community
 
moncif
Jr. Member
 
Total Posts:  8
Joined:  2010-04-30
 

I do not know how you output the price, but using

<?php echo $this->getPriceHtml($_producttrue); ?>
would show the price correctly.

So my suggestion is: check your templates too.

 
Magento Community Magento Community
Magento Community
Magento Community
 
ateetagrawal
Jr. Member
 
Total Posts:  8
Joined:  2011-08-08
 

Hello moncif,

Can you help me with the following:

Subtotal $328.95
Discount (coupontesting) -$49.34 (Discount : 15%)
Grand Total Excl. Tax $279.61
Tax $24.05 (8.6%)
Grand Total Incl. Tax $303.65

The GrandTotal has an error of 1 penny. It should be $303.64. Tried all the solutions but its not working.

Not sure why Magento has this penny issue and its not been rectified yet.

Using magento version 1.5

Please help here. Stuck badly here.

 
Magento Community Magento Community
Magento Community
Magento Community
 
moncif
Jr. Member
 
Total Posts:  8
Joined:  2010-04-30
 
ateetagrawal - 08 March 2012 05:15 AM

Hello moncif,

Can you help me with the following:

Subtotal $328.95
Discount (coupontesting) -$49.34 (Discount : 15%)
Grand Total Excl. Tax $279.61
Tax $24.05 (8.6%)
Grand Total Incl. Tax $303.65

The GrandTotal has an error of 1 penny. It should be $303.64. Tried all the solutions but its not working.

Not sure why Magento has this penny issue and its not been rectified yet.

Using magento version 1.5

Please help here. Stuck badly here.

you have no problem mate:

Subtotal $328.95
Discount (coupontesting) -$49.34 (Discount : 15%) -> should be -49,3425
Grand Total Excl. Tax $279.61 -> should be 279,6075
Tax $24.05 (8.6%) -> should be 24,046245
Grand Total Incl. Tax $303.65 -> should be 303,653745

So i see no problem wink.

 
Magento Community Magento Community
Magento Community
Magento Community
 
ateetagrawal
Jr. Member
 
Total Posts:  8
Joined:  2011-08-08
 
moncif - 08 March 2012 10:38 AM

ateetagrawal - 08 March 2012 05:15 AM
Hello moncif,

Can you help me with the following:

Subtotal $328.95
Discount (coupontesting) -$49.34 (Discount : 15%)
Grand Total Excl. Tax $279.61
Tax $24.05 (8.6%)
Grand Total Incl. Tax $303.65

The GrandTotal has an error of 1 penny. It should be $303.64. Tried all the solutions but its not working.

Not sure why Magento has this penny issue and its not been rectified yet.

Using magento version 1.5

Please help here. Stuck badly here.

you have no problem mate:

Subtotal $328.95
Discount (coupontesting) -$49.34 (Discount : 15%) -> should be -49,3425
Grand Total Excl. Tax $279.61 -> should be 279,6075
Tax $24.05 (8.6%) -> should be 24,046245
Grand Total Incl. Tax $303.65 -> should be 303,653745

So i see no problem wink.

But in display : Grand Total Excl. Tax $279.61 + Tax $24.05 (8.6%) = Grand Total Incl. Tax $303.65 (which should be $303.66). How do we correct this?

Thanks for considering my problem. Looking forward to the solution.

 
Magento Community Magento Community
Magento Community
Magento Community
 
satish
Enthusiast
 
Total Posts:  812
Joined:  2008-03-24
34,mantri Sadan,Shivaji Nagar,Nagpur,MS,India 4400
 

Rounding error is not Magento code error but it is a mathematical aspect.
this specially happens where we have tax percentage like 19% or some odd like 8.6 etc.

Simplest way to reduce chances of rounding error is not to have prices like 29.95 but to have 29.9 or 29.5 or 30.

Satish

 
Magento Community Magento Community
Magento Community
Magento Community
 
ateetagrawal
Jr. Member
 
Total Posts:  8
Joined:  2011-08-08
 

Thanks for the reply Satish.

How can we round all the subtotals, taxes, discounts and Grandtotal to 1 digit only?

Regards,
Atit Agrawal

 
Magento Community Magento Community
Magento Community
Magento Community
 
Ed P
Member
 
Total Posts:  36
Joined:  2010-03-31
 

I’m getting this too (v1.5.2.0) and it’s driving me nuts

 
Magento Community Magento Community
Magento Community
Magento Community
 
mokadev
Jr. Member
 
Total Posts:  1
Joined:  2012-01-04
 
moncif - 05 March 2012 02:49 AM

just upload the files of the attachment to the root where you installed magento. Just like installing a module. I have tested it on 1.6.2 and it works.

BTW: it works out of box smile. just empty the cach en stuff like that. Let me know if it does not work.

you have a problem in your etc/module/Experius_Taxextended.xml, the code pool have to be set to “community” and not “local”, this is why the module doesn’t work.

Thanks

 
Magento Community Magento Community
Magento Community
Magento Community
 
tony_montana
Jr. Member
 
Total Posts:  8
Joined:  2012-01-02
 

I have tried every solution but not the extension but still no luck. This is my situation:

My Vat percentage: 21%
My Magento version: 1.6.2.0

Problem 1: I have 2 products of 29€. When i go to shopping cart total it shows 58,01
Problem 2: There is a product that should be 125€ but when i use 103,31€ it doesn’t show 125 but 125,01

Any help is much appreciated. Even willing to pay if someone could help me

 
Magento Community Magento Community
Magento Community
Magento Community
 
hbeducation
Jr. Member
 
Total Posts:  2
Joined:  2011-04-03
 

There is a problem with the Experius_Taxextended module above - in etc/modules/Experius_Taxextended.xml set codePool to community instead of local:

<?xml version="1.0"?>
<config>
    <
modules>
        <
Experius_Taxextended>
            <
active>true</active>
            <
codePool>community</codePool>
            <
version>0.1.0</version>
        </
Experius_Taxextended>
    </
modules>
</
config>
 
Magento Community Magento Community
Magento Community
Magento Community
 
moncif
Jr. Member
 
Total Posts:  8
Joined:  2010-04-30
 

Thanx for the notification… you are right, i ve changed the location but did not updated the configuration smile. Thank you.

Here is an update

File Attachments
Experius_Taxextended.zip  (File Size: 17KB - Downloads: 252)
 
Magento Community Magento Community
Magento Community
Magento Community
 
mlclm
Member
 
Total Posts:  41
Joined:  2010-05-31
 
tony_montana - 04 April 2012 12:19 PM

My Magento version: 1.6.2.0

Problem 1: I have 2 products of 29€. When i go to shopping cart total it shows 58,01

Same here , this is very problematic. Any body managed to fix this on magento 1.6.2 ? I insalled the extension provided above ( thank you ) but it didn’t solve the problem for me.

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top